Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi
Try like this
=if(rank(Sum(Sales)) < = 10, Sum(Sales))
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)