Only top 5 in bar chart, but not top 5 in each dimension value.

[divya_anand]

Hi,

I am trying to create a bar chart like the one in the below screenshot. However, I would like to see only the top 5 Names. By top 5 I mean - the names with highest value of count(Name) irrespective of month. In the table, J=5, which means J belongs to Apr,Feb,Jun,Mar & May hence 5.

So, how do I show only top 5 names in the bar chart?

[sunny_talwar · Accepted solution]

I think you were using <=10 in your sample... change your second dimension to this

=Aggr(If(Rank(TOTAL count(Name),4)<=5,Name),Name)

[MK_QSL]

Is this similar post?

Show only top 10 legends, keeping the chart as it is

I mean you want to show all Name in all Months but only want to display top 5 names in Legend?

[divya_anand]

That was a very silly mistake. Anyways, Thank you Sunny.

[divya_anand]

Hi Manish,

in that post my question was on the legend.

Anyways that post had half of my answer there.

Thank you.

[sunny_talwar]

So you got what you were looking for? or are you still looking for help? If you got what you wanted, please close the thread by marking correct and helpful responses.

Best,

Sunny

[MK_QSL]

That's what I thought. In your earlier post, you have got the reply which you are looking for in this post (I think).

Anyway, close the thread if you got your answer.