Skip to Content
0
Nov 03, 2017 at 09:59 PM

% Change calculation - Design Studio

44 Views Last edit Nov 03, 2017 at 10:00 PM 2 rev

Hi All,

I have a crosstab in my report which has periods in the columns and measures in the rows. We are looking at the trend of actual numbers across all periods in a give year, in the absence of actuals we show the forecast numbers.

Now we are trying to add a row to this which will give me the % change over the previous period. I am unable to get any logic or piece of code which helps me. Any help is appreciated.

Regards,

Raja