I am struggling to prepare a report to compare weekly sales data for two years using pivot table in power query, the years (2020,2021) are the column headers and the weeks (1-7 oct,8-14 oct, 15-21 oct etc..) are in the rows. any tips will be highly appreciated. My problem is i am not able to get the years separately as the column header, since its the same date field being used. Below is a screen shot of the report I need:
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
PIVOT COMPARISON REPORT BY WEEKLY AND YEARLY
- Thread starter GoldHawk
- Start date
Similar threads
