Trepidatioussaurus
New Member
- Joined
- Oct 12, 2022
- Messages
- 9
- Office Version
- 2016
- Platform
- Windows
Hello there,
I've got a question regarding sorting of months in pivot tables. I want to display rolling 12 months as names in the correct order. E.g., newest month is July AY, oldest August of PY, then newest August AY, oldest September PY and so on. How can I sort this "correctly" within a regular pivot table (no power pivot, no manual adjustments). Here's an example:
Thank you in advance. If this is not possible in pivot table, I'll look for alternatives.
Kind regards
Stefan
I've got a question regarding sorting of months in pivot tables. I want to display rolling 12 months as names in the correct order. E.g., newest month is July AY, oldest August of PY, then newest August AY, oldest September PY and so on. How can I sort this "correctly" within a regular pivot table (no power pivot, no manual adjustments). Here's an example:
| Month Sorting.xlsx | |||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| B | C | D | E | F | G | H | I | J | K | L | |||
| 2 | Excel Pivot sorts like this with exact date | ||||||||||||
| 3 | |||||||||||||
| 4 | Jahre | (Alle) | |||||||||||
| 5 | |||||||||||||
| 6 | Zeilenbeschriftungen | Summe von AY | Summe von PY | ||||||||||
| 7 | Jan | 478 | 357 | ||||||||||
| 8 | Feb | 456 | 345 | ||||||||||
| 9 | Mär | 532 | 437 | ||||||||||
| 10 | Apr | 449 | 438 | ||||||||||
| 11 | Mai | 432 | 444 | ||||||||||
| 12 | Jun | 504 | 442 | ||||||||||
| 13 | Jul | 483 | 457 | ||||||||||
| 14 | Aug | 0 | 440 | ||||||||||
| 15 | Sep | 0 | 443 | ||||||||||
| 16 | Okt | 0 | 472 | ||||||||||
| 17 | Nov | 0 | 524 | ||||||||||
| 18 | Dez | 0 | 534 | ||||||||||
| 19 | Gesamtergebnis | 3334 | 5333 | ||||||||||
| 20 | |||||||||||||
| 21 | |||||||||||||
| 22 | |||||||||||||
| 23 | |||||||||||||
| 24 | |||||||||||||
| 25 | That's how Excel should sort (automatically, not manually like I did here) | ||||||||||||
| 26 | |||||||||||||
| 27 | |||||||||||||
| 28 | Jahre | (Alle) | |||||||||||
| 29 | |||||||||||||
| 30 | Zeilenbeschriftungen | Summe von AY | Summe von PY | ||||||||||
| 31 | Aug | 0 | 440 | ||||||||||
| 32 | Sep | 0 | 443 | ||||||||||
| 33 | Okt | 0 | 472 | ||||||||||
| 34 | Nov | 0 | 524 | ||||||||||
| 35 | Dez | 0 | 534 | ||||||||||
| 36 | Jan | 478 | 357 | ||||||||||
| 37 | Feb | 456 | 345 | ||||||||||
| 38 | Mär | 532 | 437 | ||||||||||
| 39 | Apr | 449 | 438 | ||||||||||
| 40 | Mai | 432 | 444 | ||||||||||
| 41 | Jun | 504 | 442 | ||||||||||
| 42 | Jul | 483 | 457 | ||||||||||
| 43 | Gesamtergebnis | 3334 | 5333 | ||||||||||
| 44 | |||||||||||||
Tabelle2 | |||||||||||||
Thank you in advance. If this is not possible in pivot table, I'll look for alternatives.
Kind regards
Stefan
