I have a query that returns a table with following coloumn [SectorName, ClassificationName, Turnover, Rank]. This query is used as dataset. So here distinct SectorName and ClassificationName are dynamic.
I use these as my RowGroup (Pic1) and ColoumnGroup (Pic2).
Now for ColoumnGroup we have 2 coloumns per group To display Turnover for given classification and sector. Header = <ClassificationName>.
To Display Rank for given classification and sector. Header = R. Now I want to enable interactive sort such that user can select if he wants to sort rows by values in one any coloumn.
For instance user can sort by Turnover of Classification1 next he might want to sort by Rank of classification2.