Sorting Multiple columns


#1

Hi all,

Very silly basic question, but cannot see how you do it. How do you sort a grid or nested view on multiple columns. Example, I have a nested widget on Fiscal year followed by Fiscal Period, followed by Customer which shows the sales. Sorting on period puts the first fiscal year at the top wheras I want last fiscal period at the top. Sort descending on year but ascending on period followed by sorting the measure by highest value (total of 3 sorts) I.e. its showing:

2017 - 01
- 02
-03

2018 - 01
-02
-03

I want:
2018 - 01
- 02
-03

2017 - 01
-02
-03

Thanks in advance.