Bar chart design

[#1]

Hello everyone,

Can anybody help me with bar char? Files with problem description attached,

Thanks in advance!

[swuehl]

You can try a calculated dimension like

=aggr(rank(total sum(Revenue)), Client,Country)

Hope this helps,

Stefan

[#3 · Accepted solution]

Try using the following as dimension: (see file attached)   aggr (if(Rank(sum(Revenue))<=30,Rank(Total Aggr(Sum(Revenue), Client, Country)),'-'),Client,Country)

[#4]

Thank you guys, works perfectly!!!