Forum

Notifications
Clear all

[Solved] % change YTD in Pivot Table

3 Posts
2 Users
1 Reactions
242 Views
(@ericj)
Posts: 2
New Member
Topic starter
 

I am trying to get the % change YTD done in the pivot table like the month over month (MoM) in a pivot table. I used the % difference of. I am having to manually calculate % change YTD outside of the pivot table. For example it is March 2026 and I want to know the YTD % change between ending December 2025 and January 2026, February 2026, March 2026 in a pivot table. 

Please see sample attached

Open to all suggestions

Thank you

 


 
Posted : 03/03/2026 6:30 am
Riny van Eekelen
(@riny)
Posts: 1440
Member Moderator
 

@ericj

I believe the pt in the attached file gives you the correct result. Though you might want to hide some columns since you only want the YTD % change for the overall total. Or?

 


 
Posted : 03/03/2026 4:02 pm
ericj reacted
(@ericj)
Posts: 2
New Member
Topic starter
 

@riny 

Perfect. thank you so much


 
Posted : 04/03/2026 2:36 am
Share:
0