Rank in Table

[MA1]

Hi

I try to get Rank for each Products, but now I am getting only for first Product.

Maybe Can you help me?

Thanks a lot

[zhadrakas]

try this

=Rank( total Sum( Q) ,4)

[tresesco]

May be this:

=aggr( Rank( total Sum( Q) ,4), Date, Product)

Or simply

=Rank( total Sum( Q) ,4)

[MA1]

I want to get

Product1	1.08.2017	3
Product1	2.08.2017	1
Product1	3.08.2017	2
Product2	1.08.2017	1
Product2	2.08.2017	2
Product2	3.08.2017	3

[prat1507 · Accepted solution]

Hi

If you need ranks product wise use

=Rank(-aggr( Num(Rank( total Sum( Q) ,4)), Date,Product),Product)

[sunny_talwar]

Try this

=Aggr(Rank(Sum(Q) ,4), Product, Date)

[MA1]

Thanks a lot

[zhadrakas]

you dont Need so much code

Rank(aggr( Sum( Q) , Product, Date),4)