Front end Selection Working and Set Analysis not working

[#1]

Hi All

By Selecting March from Month_New List Box I am getting the Correct Result.

But when I am adding Current Month in Calculated Dimension Set Analysis than I am

getting Wrong Result.

How to achieve the desired Output.

See this:

I have Attached the qvw for Reference.

Regards

Cire

[sunny_talwar]

Actually this:

=If(Aggr(Rank(-Sum({<Month_New={'Mar'},Code={"=Sum({<Month_New={'Mar'}>}Amount)>=20"}>}Amount)),Code, Month_New)<=3,Code,If(Month_New = 'Mar', 'Others'))

Note: Check 'Suppress When Value Is Null'

[#3]

Thanks Sir.

I have followed both the Approach.

In the end, I found below approach better:

Calculated dimension:

=If(Aggr(Rank(-Sum({<Month_New={'Mar'},Code={"=Sum({<Month_New={'Mar'}>}Amount)>=20"}>}Amount)),Code)<=3,Code,'Others')

Expressions

Sum({<Month_New={'Mar'}>} Value)

Sum({<Month_New={'Mar'}>} Amount)

Regards

Cire