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

)

[nirav_bhimani]

HI,

PFA

Regards,

Nirav Bhimani

[nirav_bhimani]

Hi,

Try This Expression to make it dynamic

In Expression:

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

Or In Dimension:

         If(AGGR (rank(sum(Sales)), Customer) <=10 , Customer)

               Or

       If(AGGR (rank(sum(Sales)), Customer) <=$(=vTop) , Customer)

Reagrds,

Nirav Bhimani

[jagan]

Hi,

Please find attached file for reference.  Also it is not possible to restrict Top n in Table box, you can use Straight table instead of Table box.

Hope this helps you.

Regards,

Jagan.

[#5]

hi,

I'm using personal edition so ur file will not be opened.....so plz do write expression in reply....

[#6]

hi,

I'm using personal edition so ur file will not be opened.....so plz do write expression in reply....

[#7]

hi,

I'm using personal edition so ur file will not be opened.....so plz do write expression in reply....

[jagan]

Hi,

I have a dimension called TEST in my datamodel, for this I used

Calculated Dimension = aggr(if(rank(FAILURE)<6, TEST),TEST)

Expression = Sum(FAILURE)

The above displays the top 5 Tests which has highest failures.

Hope thie helps you.

Regards,

Jagan.

[nirav_bhimani]

HI,

For the expression see my earlier post .

Reagrds,

Nirav Bhimani

[#10]

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......