Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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
see this
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????
Bump
