Can anybody help me with bar char? Files with problem description attached,
Thanks in advance!
You can try a calculated dimension like
=aggr(rank(total sum(Revenue)), Client,Country)
Hope this helps,
Try using the following as dimension: (see file attached) aggr (if(Rank(sum(Revenue))<=30,Rank(Total Aggr(Sum(Revenue), Client, Country)),'-'),Client,Country)
Thank you guys, works perfectly!!!
Retrieving data ...