Forum

Notifications
Clear all

PIVOT TABLE - GET DIFFERENCE FOR (2019-2020) SUB TOTALS

2 Posts
2 Users
0 Reactions
88 Views
(@rehan)
Posts: 2
Active Member
Topic starter
 

How to get difference between data compiled for let say two years 2021/2022

preferably for each month (sub totals) JAN, FEB, MAR, APR  ........ 

appreciate if any one can assist.

 
Posted : 27/06/2023 4:00 am
(@mynda)
Posts: 4761
Member Admin
 

Hi Syed,

It's difficult to answer without an example file, but you might find these tutorials helpful:

Excel PivotTable Show Values As • My Online Training Hub

Excel PivotTable Month Comparison [Video] • My Online Training Hub

If you're still stuck, please provide an example Excel file.

Mynda

 
Posted : 28/06/2023 8:35 pm
Share: