Discussion board where members can get started with QlikView.
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.
Try the attach application.
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