Graphs - Top X displayed - is it possible to use a drop down list to control?

[#1]

Hi all,

Is there a way to enable the user to specify what the top x should represent (in a graph)?

ie in the graph itself, a user can manually specify the max number of "slices".

Is there a way to replicate this functionality using a drop down listing?

Please advise,

Kind regards,

Rich

[brenner_martina]

Hi,

the Example shows, that it is possible for a bar or line chart but unfortunally not for a pie chart!

[prieper · Accepted solution]

You may put enter into the piechart max number of slices to be 99 or the like (Properties - Presentation - Maximum Number of Slices) and replace the dimension Supplier with a calculated one:

=IF(AGGR(RANK(SUM(Spend)), Supplier) <= [Top x], Supplier, 'Other')

Same you may do in the other chart-types as well.

HTH
Peter