period over period growth%

[#1]

Hello,

I'm trying to build a period over period growth % chart(not pivot table) but so far I didn't find a way to do that.

I was able get this in a pivot table using the before() function, but I want to do it also in a bar chart.

This is the formula I used for the growth % in the pivot table:

SUM(Amount)/Before(SUM(Amount)) - 1

Is there a way to do this in a chart? My time dimension is based on months.

Thanks in advance,

Daniel

[swuehl · Accepted solution]

In a straight table chart (or bar chart), try with the above() inter chart record function:

SUM(Amount)/ ABOVE(SUM(Amount)) - 1

[#3]

Hi Swuehl,

It works with Above().

Regards,

Daniel