display OTHERS row in a straight table

[sonikajain]

Dear all,

I am  stuck in  a scenario where I need to display top 10 rows based upon gross revenue, and there are 3 dimensions in the table -

Country, City and Contact name, and the rest in a separate row ALL others.

I am able to achieve this additional rows for rest of the data when I use a single dimension, but here I have 3 dimensions, and so, the row for OTHERS is not visible.

Please help me with this.

Sonika Jain

[deepakk]

hi Sonika,

Try the attach application.

Deepak

[#3]

Dear Sonika,   Try adding a fourth calculated dimention like:   =aggr(If(Rank(sum(Mins)/sum(TOTAL Mins))<=10,'Top 10','Others'),Country)  To create the thwo groups. Please see file for example.  Regards  Rahul Lakhina