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