top 5

[master_student]

Hello Guys,

I need to display in a table, only the top 5 amount recharge, i know how to do it in a graph but not in a table.

[felipedl]

Hi Wiem,

In the DImension limit tab (see bellow) there's the option where you mark the top 5.

In this case, the Recharge AMount must be your first expression, so it gets the top 5 for this amount.

Felipe

[imrasyed]

Hi,

You can first sort the values based on the expression.

Then In the Presentation Tab check the Max checkbox and give the limit to 5.

Is this the one you are wanting or anything else?

Note: Message edited by Community Moderator to correct spelling and eliminate shorthand. Please use correct spelling and do not use shorthand or slang because this is a global community and many members rely on translation tools to understand and communicate in other languages.

[master_student]

i don't have dimensions limits, in my table graph propreties. see bellow :

[krishnacbe]

In Pivot table you can set Dimension Limits. Try with Rank() function.

[Anil_Babu_Samineni · Accepted solution]

Pivot doesn't have dimension limit offer, So you can create like below

=if(aggr(rank(sum(Sales)),[Description offre])<=5,[Description offre])

[its_anandrjs]

You can use any straight table chart for display Top 5 and for input value in variable you can use input box or put your default value like 5 or 10