Forum Discussion
Hierarchy level change sort order in matrix table
Hello...
Could you please help with the following: 1st I have a matrix table with items that have been sold to my customers, this is sorted in the amount sold column to see what Items have the greatest sales value... down to the least for all my customers. However I have added a drilldown with month and year and require these months to be sorted not in sales value order but now in month year order????
Is this possible 😉
So just to explain further I can see my top customers based on sales value (sorted in descending order), then I can drill down and see their products bought... this is also sorted in sales value order (perfect). Then I can drill down further to month year but this is also sorted in sales value order and not month year like I need it 😉
First Level in Hierachy
Second Level in Hierachy:
Third Level in Hierachy and this is where I need help... the sort is using the previous sort order and not my date order:
Thanking you in advance
Mark
2 Replies
- v-luwang-msft
Community Support
Hi MarkRustin ，
About how to sort in matrix ,you could refer the below sample:
Sample
Sample:
Result:
And if question sitll not solved ,could you pls share your sample data and expect output.
Best Regards
Lucien
Hello Thank you v-luwang-msft ...
Unfortunately this is not what I am after... going to try and take some screen shots... have a look below.
First levelSecond Level in Hierachy:
Third Level in Hierachy and this is where I need help... the sort is using the previous sort order and not my date order:
Thank you, hope this makes it clearer to understand.
