return the quantity of assets from the max sum(Price) from a category

[thanhphongle]

Hello Community,

This is my database:

Category	Product	Price
Laptop	Asus Zen	300
Laptop	Sony f12x	400
Laptop	Apple Mac Pro	800
PC	Alienware Pro	2000
PC	HP Gaming X4	1500
Mouse	Razor Diamondback	50
Keyboard	Logitec Wireless	30
Mouse	Logitec G5	60
Headset	Creative GX 8	80

I want QV to return me quantity of assets considering the max sum(Price) of a Category.

In this case it should return me:

Category = PC and Quantity = 2

This is my expression which i m using. But somehow it is not working correctly.

Concat(DISTINCT {<Category = {"=Aggr(Sum(Price), Category) = Max(TOTAL Aggr(Sum(Price), Category))"}>} Categoy, ', ') & ' \n'

& Max(TOTAL Aggr(count(Category), Category))

Could anyone help me out here?

[MK_QSL]

This one is also working...

[thanhphongle]

LOL, now it s working for me as well. I swear I followed your instructions and it still gave me 61 as quantity! But thank you guys anyway !

[sunny_talwar]

Hahahaha I am glad it finally worked. We need a lot of helpful answers from you on this post and of course a correct answer

[MK_QSL]

I know why it was not working for you... and you was getting 61... Because you was just doing copy paste our expression into your application. But you forgot to change

COUNT({<Category = {"=RANK(SUM([Selling price]),4)=1"}>}Category)

to

COUNT({<Category = {"=RANK(SUM([Selling price]),4)=1"}>}[Serial Number])

Am I right?