Pivot table : Ability to sort sub dimensions by measure
>THere is major improvemnt to ring to pivot tables: Sort by measure, and including sorting in sub dimension. Let me explain.
You can sort the 1st dimension by measure. But if you expand 1 cell of the 1st dimension , sort is not applied on the sub dimension . This is very frustrating. We have tried to apply some set analysis and
conditional formula, try several way found on internet, but all have issues, and are not functioning.
Example that works in Excel: CONTINENT SORT BY UNITS measure
Currently impossible to do that with QLIKSENSE, as far as I know, even with set analysis in the Sort section.