Ton n analysis

[gauthamchilled]

hi

how to create to top n analysis with multiple dimensions.

looks it will work only for 1 dimension

Can you any one give example?

[avinashelite]

I think you need to make use of the Aggr() function with all the necessary dimension

eg: AGGR(sum(sales),Dim1,Dim2,Dim3) and use RANK function along with to achieve the desired results

Top N list with 2 dimensions

Top N in Pivot/Straight table with multiple dimension

[Kushal_Chawda]

see this

Top N list with 2 dimensions

[gauthamchilled]

Thanks. but i am able to achieve this using the aggr function by your directions.

but how can i show others at the bottom..like we do in dimension limits????

[gauthamchilled]

Bump