Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi.
Category | Item | Quantity | Rating_quantity | Price | Rating_price |
---|---|---|---|---|---|
food | Milk | 17 | 2 | 50 | 2 |
food | Cola | 10 | 4 | 19 | 3 |
food | Cake | 22 | 1 | 70 | 1 |
food | Banana | 7 | 5 | 16 | 4 |
food | Сookies | 14 | 3 | 5 | 5 |
furniture | Chair | 4 | 4 | 100 | 2 |
furniture | Table | 3 | 5 | 90 | 3 |
furniture | Sofa | 6 | 2 | 30 | 6 |
furniture | bla1 | 8 | 1 | 80 | 4 |
furniture | bla2 | 5 | 3 | 75 | 5 |
furniture | bla3 | 1 | 6 | 110 | 1 |
Category and Item is dimension.
How can i do Rating_quantity and Rating_price? (Rating in category)
Pivot or Strong table - unimportant.
Thank you!!
=Rank(sum(Qty),4,1) its work! mode 4 and format 1.
Jason Michaelides, tnx for help!
Try:
Rank(Sum(TOTAL <Category> Quantity))
and
Rank(Sum(TOTAL <Category> Price))
Hope this helps,
Jason
the result is min-max:
1-1322
1-1322
1-1322
1-1322
1-2372
1-2372
1-2372
1-2372
=Rank(sum(Qty),4,1) its work! mode 4 and format 1.
Jason Michaelides, tnx for help!