Sum of Top 10 Rank

[d4rlie891]

Hi,

I want to sum the Top 10 Rank with Category = "DPK", Anybody can tell me what is wrong with my Measure :

Sum({<CUST_NAME = {"=Rank(Sum({$<MONTHYEAR = {"$(=max(MONTHYEAR))"}, CATEGORY = {DPK}>} BALANCE_IDR)) <=10"}>} BALANCE_IDR)

I can get the total of Sales with this measure :

sum({$<MONTHYEAR = {"$(=max(MONTHYEAR))"}, CATEGORY = {DPK}>} BALANCE_IDR)

)

Thanks

[sunny_talwar]

Try not to post same requirement multiple times.

Need Correction

How to Sum Top 10 Rank

Thanks,

Sunny