Hi, 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 the format I need in my pivot report.
-
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.
Excel Pivot Tables
- Thread starter GoldHawk
- Start date
-
- Tags
- pivot table
Similar threads
- Question
- Question
