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.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
Excel Pivot Tables
- Thread starter GoldHawk
- Start date
-
- Tags
- pivot table
Excel Facts
Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.
Similar threads
- Replies
- 1
- Views
- 252
- Replies
- 1
- Views
- 329
- Question
- Replies
- 2
- Views
- 107
- Replies
- 3
- Views
- 251
