How to sort Overall Profit % even when viewing All People


Can anyone assist me about Sorting my Project Profit %~ by ascending order and doesn’t change the order even viewing all people/employees?


You can use Order by a measure in the report. The order might fail in some complex reports/scenarios. If you will look into details by expanding a dimension with several levels in the hierarchy on lowest levels or if there are any other dimensions you would like to expand and see the details the ordering will fail.

Daina /

1 Like