Rank problem

[#1]

Hi all,

     I have a qvw app which contains only 1 table:

prd	sales	area
p1	27	a
p2	17	a
p3	15	a
p4	15	a
p5	29	a
p6	29	a
p7	21	a
p1	28	b
p2	27	b
p3	29	b
p4	26	b
p5	20	b
p6	17	b
p7	20	b

I want to create a straight table:

Dimension: area

Expression:

         1. mkt size=sum({<prd=>}sales)

         2. prd sales=sum(sales)

         3. rank = i do not know

when selecting 1 prd (say 'p1'), the 'rank ' expression will shoe the ranking of 'p1 'in each area.

if i select 'p2' , the right appearence of this straight should be:

area	mkt size	prd sales	rank
a	153	17	4
b	167	27	3

how this 'rank' expression should be ? Thank you all in advance!

Attachment is my app.

[Anonymous]

Hi

Try this this is working

=Rank(sum(sales))

Regards

Harsha

[#3]

try this

aggr(rank(sum(sales),prd,area))

[kristoferahlin · Accepted solution]

Hi,

Please see attached example.

Regards,

Kristofer

[#5]

Thank you. You got the right rankings. But i still don't know why the ' {<prd=>}' should be added in the expression.

Anyway i will use your expression.  Thanks again.