Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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'
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