Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a table and Product is my dimension; How can I specify to show only TOP 10 Products
({<STATUS_CODE ={'ABC','DEF'},LOCATION_COUNTRY_CODE = {'US','CA'}>}[PRODUCT])
It looks you have old version.. if you are showing top 10 based on your measure then use rank in measure. below example:
Sum({<Customer = {"=Rank(Sum(Sales))<=10"}>} Sales)
Regards,
Arunesh
This should be available as one of the options under the dimension properties.
The problem is : Its not showing that
It looks you have old version.. if you are showing top 10 based on your measure then use rank in measure. below example:
Sum({<Customer = {"=Rank(Sum(Sales))<=10"}>} Sales)
Regards,
Arunesh