How To Filter Top 10 Dimension Members

[#1]

Hello,

I currently have a chart that I am filtering top 10 by presentation property "Max Visible Number"=10

I want to remove this filter, and apply it in the Dimension coding.

How do I filter top 10 Partner Dimension based on the following expressions in decending order

Sum({<LOB={HOTEL}>}Booking)

Your help is appreciated.

[Sokkorn]

Hi,

I have one idea but don't know this one help you or not.

1. Create one variable <vMaxShow>
2. Create Slider/Calendar Object (For dynamic show max)
- Variable(s) : vMaxShow
- Min Value : 1
- Max Value : 100
- Static Step : 1
3. Right Click on Chart ==> Presentation
- Max Visible Number : Choose variable <vMaxShow>

Regards,

Sokkorn

[s_uhlig · Accepted solution]

Hi,

you can do something like

aggr(only({<Partner={"=rank(Sum({<LOB={HOTEL}>}Booking),4)<11"}>}Partner),Partner)

but your solution is preferable.

Regards

Sven

[#4]

Hello Sven,

You solution seems to work as it filters top 10 Partner.  However, I'm getting an additional bucket "-" that seems to group all else.  Is there a way to filter out this bucket?

Any help on this is appreciated!

[s_uhlig]

Sure, there is a checkbox "Suppress When Value Is Null" below your dimension.

[#6]

It works like a charm.

However, since the dimension is the long calculated expression.  It does not show the actual Partner for each bar (dimension members).  It just shows the entire dimension expression.  Do you know how it can render the dimension labels correctly?

Your help is appreciated!

[s_uhlig]

Hi,

I'm sure you will figure it out yourself. The direction is pretty much the same as one before.

Regards

Sven