I am using the rank function in the dimension to show the Top 10 destinations by minutes. 2 dimensions i have given week and destination. expression is simple sum(Minutes).
Please look at the attached image. But it is not sorted properly. I didn't mention anything in the Sort tab. Should i have to give any expression in the Sort tab.
=if(aggr(rank(sum(Int_Mins)),zone_country_name)<=10,zone_country_name). This is the dimension
Hi all, can anyone help me. In the top10.jpg I want to show the total of all destinations for the respective week. Currently what happened was the total is showing only for the Top10 destinations, not for all destinations. Use the top 10 - in Pivot table.qvw document. Thanks, Raghu.
