Rating in dimension (pivot or strong table)

[#1]

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!!

[Jason_Michaelides]

Try:

Rank(Sum(TOTAL <Category> Quantity))

and

Rank(Sum(TOTAL <Category> Price))

Hope this helps,

Jason

[#3]

the result is min-max:

1-1322

1-1322

1-1322

1-1322

1-2372

1-2372

1-2372

1-2372

[#4 · Accepted solution]

=Rank(sum(Qty),4,1) its work! mode 4 and format 1.

Jason Michaelides, tnx for help!