showing top 5 using table and filter pane

[sanpor1zd]

Hello,

I have a filter pane with zipcode
and a table to show the top 5 price base on the filter.

by using

=if((GetSelectedCount(Zipcode))=1,if(Rank(Price)<=5,Zipcode),Zipcode)

everything is fine with 2 dimension for my table, zipcode & price.

as shown from the pic above, the middle table is working out fine with 2 dimension, however when i add in a hostname, things started to go wrong. 

any way to go around this?

thank you 

[rubenmarin]

Hi, in the sample Zipcode loaded as a measure and Price as a dimension, in this case you can set the dimension limit for price: