set analysis help

[#1]

Hi Friends,

I have the following expression which works as expected. However I don't want it to respond to MONTH selections. Now when I click on any month it still filters to show only that month. Please help!

aggr(RangeSum(ABOVE(SUM({1<KPI_NAME={'$(vKPIChecking)'},MONTH=>}COMBO_NEW_GOAL_VALUE),1,MONTH-1)),MONTH)

Thanks,

Weiting

[vinieme12]

Try

aggr(only({<MONTH>}RangeSum(ABOVE(SUM({1<KPI_NAME={'$(vKPIChecking)'},MONTH=>}COMBO_NEW_GOAL_VALUE),1,MONTH-1))),MONTH)

[sunny_talwar]

May be this:

Only({<MONTH>}Aggr(RangeSum(ABOVE(SUM({1<KPI_NAME={'$(vKPIChecking)'}, MONTH=>} COMBO_NEW_GOAL_VALUE), 1, MONTH-1)), MONTH))

[#4]

Thanks Sunny,

I added only function as you suggested but it's doing the same thing... When I filter on any month, it's only showing me that month data point versus the whole year..

Any other ideas?

Weiting

[sunny_talwar]

I see the issue now, try this:

Only({<MONTH>}Aggr(RangeSum(ABOVE(SUM({1<KPI_NAME={'$(vKPIChecking)'}, MONTH=>} COMBO_NEW_GOAL_VALUE), 1, Only({<MONTH>} MONTH)-1)), MONTH))

[vinieme12]

have you tried the below

aggr(only({<MONTH>}RangeSum(ABOVE(SUM({1<KPI_NAME={'$(vKPIChecking)'},MONTH=>}COMBO_NEW_GOAL_VALUE),1,MONTH-1))),MONTH)

[#7]

Hi Vineeth,

Thanks for the reply. Yes I tried your approach and it doesn't work...

Any other ideas please?

[#8]

Still filtering on month...

Not sure what's going on...

[sunny_talwar]

How do you define vKPIChecking?

[#10]

vKPIChecking= 'New Checking Accounts'