I have to show top performing cities based on Net Profits. I have one dimension which is city and 4 other expressions showing Revenue, Cost, Gross Profit and Net Profit. The customer wants to see only top 3 performing cities based on net profit in a straight table chart.
Dimention limit to 3, and further in straight table I sort to required expr., asc or desc.
Note, that if you use expr that is a result of calcualtion based on the values of other expr, f.e. sum(Gross-Cost) so it is ok, but if you will use the construction with Cloumn(1)-Column(2) sorting by double clicking the expr in straigh table will not working.