Plz help me regarding finding the top 10 highest amount in using pivot table and also in table box

[#1]

Plz help me regarding finding the top 10 highest amount in using pivot table and also in table box?
I am using the following expression but i'm getting only first 4 values correct.....

if

(aggr(rank(sum(amount)),amount)<=10,product_category

)

[#2]

I am using 3 columns (amount,product category and potential name).
I want top 10 highest values from amount column.

I used the formula in both calculated dimension and in expression but im getting wrong result....
might be because of supress zero values checkbox....

If i deselect the Supress zero value then i get the specified result but here top 10 values are not coming , whole data is displayed......

[kaushiknsolanki]

Hi,

     Have a look at the expression given by Mr. Nirav.

    only change requied in that expression is to remove the '='. So your expression will be like below.

     sum({<Customer={"=rank(sum(Sales))<=$(vTop)"}>} Sales)

Regards,

Kaushik Solanki