Continuous rank

[wanyunyang]

Hi guys,

I have a table like this:

Customer, Item, Sales

A, aaa, 5

A, bbb, 5

A, ccc, 2

...

I want to rank the sales by customer and item, and this is the function I use:

aggr(rank(Sales),Customer,Item)

The results end up like:

Customer, Item, Sales, Rank

A, aaa, 5,  1

A, bbb, 5, 1

A, ccc, 2, 3

...

I wonder if it's possible for the third row to have Rank=2?

[Vegar]

This might solve your problem

=aggr(NODISTINCT rank(sum(Sales)), Sales)

[Ksrinivasan]

hi,

try this

=aggr(rank(sum(Sales)), Customer, Item)

ksrinivasan