Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
sonikajain
Partner - Contributor
Partner - Contributor

display OTHERS row in a straight table

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.

straight table.jpg

Please help me with this.

Sonika Jain

2 Replies
deepakk
Partner - Specialist III
Partner - Specialist III

hi Sonika,

Try the attach application.

Deepak

Not applicable

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