Rank Function

[#1]

I want to create following pivot table that shows rank of products.

	Market 2		Market 2
Prroduct	Sales	Rank	Sales	Rank
P1	100	3	50	4
P2	200	2	500	1
TOTAL	300		550

But when I created this in qlikview pivot table I got the following results. Its showing the rank of products by market and is not what I

	Market 2		Market 2
Prroduct	Sales	Rank	Sales	Rank
P1	100	2	50	2
P2	200	1	500	1
TOTAL	300		550

I am using this expression to calculate rank.

Rank(TOATAL sum(Sales))

Can any one help me how to calculate rank as shown in first table?

[#2 · Accepted solution]

Hi,

You need to use a function AGGR into your expression.

[#3]

Great!

Exactly what I needed.

Thanks again.

Zubair.