Need Correction

[d4rlie891]

Hi,

Anyone can correct my Measure?

I just want to Sum Top 10 Rank.

The Result is OK, if I select a Year_Month, but if I don't select any Year_Month, the Result is incorrect.

This is my Measure:

Sum({<CUST_NAME = {"=Rank(Sum(BALANCE_IDR_DPK))<=10"}>} BALANCE_IDR_DPK)/1000000000

I need to add Max(MONTHYEAR) into that measure.

I try to create the measure like this, but it seem not working.

Sum({<CUST_NAME = {"=Rank(Sum({$<MONTHYEAR = {"$(=max(MONTHYEAR))"}>} BALANCE_IDR_DPK))<=10"}>} BALANCE_IDR_DPK)/1000000000

Thanks

Dmw

[sunny_talwar]

How does your MONTHYEAR field look like? Is it a dual field (with numeric value) or is it text? Can you share a screenshot of MONTHYEAR field?