substract calculated fields within pivot colums/rows

Hi all,

I'm having some troubles while creating my desired pivot table. I created a simple pivot table with some calculated fields.

The dataset contains sales figures (revenues, costs, margin) for two years.

The created pivot shows for each year the average revenue, average costs and average margin.
I added calculated fields that show the % difference between the two years for all of these averages.

So far i'm experiencing no problems. No however, i'd like to substract the % differences that I've calculated.
Is this calculation possible within the pivot table? Attached you'll find an example file where I calculated the desired values in a seperate row.

Thanks in Advance.

Kind Regards,
AntonH

Maybe use Calculated Item

I already tried to add a calculated item to get the job done, but unfortunately I couldn't figure out how to get the desired result.

Because I don't remeber well Ex2007 so maybe it will help: Excel Pivot Table Calculated Item

Thank you, but unfortunately i still haven't found a solution. I'm using excel 2016 version by the way..

Calculated Field doesn't work with Average and some more. Probably you will need to reoragnize your PivotTable

Possibly.. but how?

Create AVERAGE column(s) in source table then PT then Calculated Item