
Partner - Creator III
2021-06-07
09:48 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Month sort order not done in natural way
Hello,
I'd like to sort the month by descending order in a pivot table. I set the sort option in the properties pane in the manner below, but it is not sorted in the descending order as intended. I'd appreciate it if anyone can tell me where I am going wrong with this.
Thank you for your help.
3 Replies


Specialist III
2021-06-08
05:34 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
In expression try with :
Only({1} MONTH)
552 Views

Partner - Creator III
2021-06-09
04:14 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thanks I tried, but I get the error message like below.
But anyway, I solved that issue by an alternative way.
523 Views


Specialist III
2021-06-10
06:11 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
So, your field is Month not MONTH as in my exemple.
504 Views
