Need Correction

d4rlie891 — Wed, 29 Jun 2016 09:57:50 GMT

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

Re: Need Correction

sunny_talwar — Wed, 29 Jun 2016 16:22:16 GMT

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?