How To Filter Dimension Members

[#1]

Hello,

I have a listbox using dimension called Partner, and it contains all the available Partner list.

However, for the specific Hotel chart, I only want the listbox to show Partner that have Booking>0

Here's the Booking expression:  Sum({<LOB={HOTEL}>}Booking)

How do I use an expression in the listbox to return only the Partner with Booking>0?

Your help is appreciated!

[#2 · Accepted solution]

Hi,

This should work:

if(aggr(Sum({<LOB={HOTEL}>}Booking),Partner)>0,Partner)

Regards,

Kiran

[#3]

Similar question on dimension filtering. 

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.

[#4]

Instead of the aggr function you can use rank function with condition rank <=10.

Regards,

Kiran.