Calculation in Pivot table

[PeterHMR]

Hi

As a Sales Analyst I'm constantly crunching data. I often use pivot tables as they are quick and handy. However I'm running into an issue.

The data source is a simple list of sales per month per customer. In the pivot I have the months in the columns and the following measures in the rows:
- Actual 2016
- Actual 2017
- Actual Growth (by using a Calculated field)
- Plan 2017
- Plan Growth (by using a Calculated field)
- Cumulative Actual 2016 (by using Running Total)
- Cumulative Actual 2017 (by using Running Total)
- Cumulative Plan 2017 (by using Running Total)

What I want to add is the growth for the cumulatives. However I'm not able to.

Does anyone have an idea how to do it?

Thanks for your help!

Regards,
Peter

 

[witsonjoyet]

Could you share the sample data file?

 

[PeterHMR]

See attached (if it works, which I doubt)