Rankings Help

[#1]

I am trying to create rankings i.e Top 25, Top 30 based annual sales with-in variance groupings i.e products, industry, etc....

However,  the trick is getting the remaining customers as cumulative sub-total within the total (see table below)

Rank	Customer	Sales
1	a	10
2	b	9
3	c	8
4	de	7
5	fg	6
6	Others	10
Total	50

I can create this in excel, I have created the result set within an sql if using oracle just cant get the aggregate function in Qlikview.

Any help is greatly appreciated.

Thanks

[#2]

try using dimension limits .

Else, please attach the qvw document.

[Clever_Anjos]

Use Dimension Limits, that´s why they´re were made

[#4 · Accepted solution]

Hi,

You can also create a Calculated Dimension:

=Aggr(If(Rank(Sum([Sales]))<5, FABRICANT_LName, 'Others'),  FABRICANT_LName)

Your expression will be Sum(Sales)

Fabrice

[annafuksa1]

please look at file I have attach

[#6]

thanks this is what I was looking for !!!

[#7]

no attachment

[annafuksa1]

not working ? or you cant open ?