Notifications
Clear all
General Excel Questions & Answers
2
Posts
2
Users
0
Reactions
16
Views
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
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