Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi
If you need ranks product wise use
=Rank(-aggr( Num(Rank( total Sum( Q) ,4)), Date,Product),Product)
try this
=Rank( total Sum( Q) ,4)
May be this:
=aggr( Rank( total Sum( Q) ,4), Date, Product)
Or simply
=Rank( total Sum( Q) ,4)
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 |
Hi
If you need ranks product wise use
=Rank(-aggr( Num(Rank( total Sum( Q) ,4)), Date,Product),Product)
Try this
=Aggr(Rank(Sum(Q) ,4), Product, Date)
Thanks a lot
you dont Need so much code
Rank(aggr( Sum( Q) , Product, Date),4)