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:
I’ll bump this one as was going to post something similar.
I find I need to sort by multiple columns too maybe one property and one measure, or sometimes more than one measure - e.g. Weeks Cover + Stock Value or multiple columns of an Aged Debt report.
Thanks for the suggestion. We have passed this through to our designer to see what we can do (early days). We will initially look at this in the main grid and will review if it is functionality which fits with the nested grid.