VBA_Cancer
New Member
- Joined
- Nov 6, 2017
- Messages
- 17
So I have a pivot table that looks like this
How do I sort the week/year column in pivot table so that it first sort by the year and then the week number so that it looks like this?
Week/Year | data1 |
1 2019 | 454 |
1 2020 | 545 |
2 2019 | 454 |
2 2020 | 343 |
3 2019 | 55 |
How do I sort the week/year column in pivot table so that it first sort by the year and then the week number so that it looks like this?
wee/year | data1 |
1 2019 | |
2 2019 | |
3 2019 | |
4 2019 | |
1 2020 | |
2 2020 | |
3 2020 |