Report Sort Order Seems Broken

I have a list of products by t-shirt size, (S,M,L), i wanted the specific line items to be grouped and sorted by t-shirt size, but it only sorts them as L,M,S in alpha order.
So i created a helper column called sort order which assigns 1=S, 2=M and 3=L.
When i sort the report by sort order it works, but as soon as i group it by t-shirt size the sort order goes back to alpha by t-shirt size eventhough i specifically have the sort to be by the column "sort order"
Why is this happening? Is this a bug?
Answers
-
The grouping will always override sorting, but you can adjust the sort order of the grouping when creating the grouping.
-
how do i adjust the sort order of the grouping? it always groups alphabetically, i don't want that.
-
In the case of S, M, L being sorted as L, M, S instead would be changing the sort order from ascending to descending when grouping.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.2K Get Help
- 431 Global Discussions
- 152 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 74 Community Job Board
- 501 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 306 Events
- 36 Webinars
- 7.3K Forum Archives