Calculated Dimension and Rank

[#1]

Hi,

I´m working in a a table chart like this

Product StoreSales RegionSales NationalSales

I created a calculated dimension to only appear products with NationalSales>0, so no zero (Store, Region, National) Sales appear on the table.

This works fine, the problem is when I insert a column with Rank, for example, Product Store Rank, when I do this the calculated dimension is not working anymore and zero National Sales appear on the table.

What can I do?

Thanks in advance,

Francisco

[#2 · Accepted solution]

I found a solution that works for this case...

Instead of using rank I used Market share for ranking the products in Store, Region and National, and the calculated dimension works fine!

Thanks any way...

Regards,

Francisco.