ListBox with Top N values

[pradnyat]

Hello All,

I have one listbox with the inline fields : 5,10,15,All.

If user selects 5 then I want to change the chart with top 5 sales and like that.

I am using this field name in Dimension limits option. This is working fine for 5,10,15.

But I want the functionality like if user selects All, then it should display all the data, but its not working.

Can anybody help me with this.

Thanks in advance...!

[Gysbert_Wassenaar]

Try rangemin(only(MyListboxField), 9999999)

[pradnyat]

Hi Gysbert,

I don't want to directly give the maximum value 9999999. Is there any other way that we can use some function to find out the number of rows in output and give that value there.

[tresesco]

Yes you can use something like:

=rangemin(only(MyListboxField), Count( Distinct <YourFieldInDimension>)+1 )

[Gysbert_Wassenaar]

Why not? Surely you don't intend to show 10 million rows in your chart?

[VishalWaghole · Accepted solution]

Hi Pradnya,

PFA and try this,

=rangemin(only(ListboxField), Count( Distinct <Dimension>)+1 )

Hope it will work for you.

- Regards,

Vishal Waghole