Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everyone,
Can anybody help me with bar char? Files with problem description attached,
Thanks in advance!
Try using the following as dimension: (see file attached) aggr (if(Rank(sum(Revenue))<=30,Rank(Total Aggr(Sum(Revenue), Client, Country)),'-'),Client,Country)
You can try a calculated dimension like
=aggr(rank(total sum(Revenue)), Client,Country)
Hope this helps,
Stefan
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!!!