Compounded growth rates in as a calculated item or SVA in a table

Hello,

I was wondering if it is possible to create a CAGR % in a table (via calculated items or SVA). At the moment I have a separate metric that calculates a CAGR on a granular P&L level, but once I pull that metric in my table it simply sums or flat-out averages that metric for the higher P&L levels.

Does anybody know if there is some smart way to recreate a CAGR SVA or calculated item in a Pigment table?

Thanks, Bas