Top 10 in Pivot table

[#1]

Hi All,  

            I have a pivot table in that have Brand dimension  in that have almost 30 brands is there

so now  i want i pick top 10 Brands based on sales there is no dimension limit Tab for pivot  table so can u suggest how we can restrict the top 10 brands in pivot table

thanks In Advance

[MayilVahanan]

Hi

Try like this

=if(rank(Sum(Sales)) < = 10, Sum(Sales))

[#3]

You have to use a calculated dimension. You cant use sum and other aggregation function inside a IF statement like that. You have to use something like the below mentioned. In aggr I have used brand to aggregate, you have to mention all fields you are using as dimensions.

=AGGR(If(Rank(sum(Sales))<=10,Brand),Brand)