Forum

Notifications
Clear all

Percent Changes in Pivot Table Showing Totals

2 Posts
2 Users
0 Reactions
79 Views
(@roseventura)
Posts: 2
Active Member
Topic starter
 

I watched your video   >>  https://www.youtube.com/watch?v=FOBQHNzQmGA&lc=z221ff5p3yuzstx2yacdp435m3b5lom5beot2evofw5w03c010c

This works perfectly for me and even shared it with other colleagues. My one question is that my % column and my Change column both show totals at the bottom. In your example the totals are blank. What did I miss?

See attached file.

Thanks,

Rose

 
Posted : 13/11/2021 5:12 pm
(@mynda)
Posts: 4761
Member Admin
 

Hi Rosemary,

Because your time series are going across columns, whereas mine were in the rows. It's therefore, giving you the total percentage change quarter on quarter.

Mynda

 
Posted : 13/11/2021 9:36 pm
Share: