Calculated Item - Pivot Table

[Deonvg]

Hi all,

Need some help please. I have inserted "Calculated Item's" in a pivot table
1. New calculation to calculate the movement in ABS from 2023 compared to 2022 - this piece works fine as the Totals and Grand Totals sum correctly.
2. Added an additional "Calculated Item" that calculates the % growth for me year on year i.e. (2023-2022)/2022. For the individual line items, the %'s is calculated correctly, but as soon as it does the Total or Grand Total it sums the various percentages (%) instead of doing a calculation for that as well based (2023-2022)/2022. The 139.28% should be showing 68.41%

What is the correct method to get this working? Your help will be appreciated.

 

[GlennUK]

Why don't you do Difference From Previous (the ordinary one and also the percent one):

 

[Deonvg]

@GlennUK thank you for the feedback.

Not sure what I'm doing wrong, but can't seem to mimic your view, would you be so kind to help out with the xls if possible or guide me on picture. Have added both "Calculated Items" and Calculated Fields" with no luck. Item isn't the correct option

I know it is something fairly easy, but just not seeing it at the moment.

Thanks in advance.

 

[GlennUK]

Have an extra column with real date, generated by referencing your Year/Period field. Get rid of all calculated fields. Generate PivotTable, grouping date by year. and then do the same as I did

 

[Deonvg]

Thanks @GlennUK - got it sorted.

 

[GlennUK]

Excellent - glad to have helped