In the below straight table we show top 10 ranks. Now I want to remove the Rank expression but the issue is in the Sales column it is showing all the values since Rank is removed. Is there is any way to show the top 10 Sales without Rank column? Please help!
rank(sum({1}sales)) based on the dimension also get result for example you give the dimension city or state country dependence upon the dimension you got that
Could you show some sample lines of your chart with the dimension(s) and expression values you get and then show how you would like the chart to be sorted (and add a short description how you've derived the order).
There are several methods how to derive a rank from multiple other ranks.
Thanks swuehl before I fix the sorting issue I need some important changes in the chart. I need your help on that very urgently. Will get back to you in sometime.
Rank 13 that you see the excel it dynamic. I mean Top 10% of selected date range so it was be anything. So when I use TOTAL it is summing all the Sales value instead of summing only the Rank 13. Hope the issue what i am facing is understandable.
