Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try
aggr(only({<MONTH>}RangeSum(ABOVE(SUM({1<KPI_NAME={'$(vKPIChecking)'},MONTH=>}COMBO_NEW_GOAL_VALUE),1,MONTH-1))),MONTH)
May be this:
Only({<MONTH>}Aggr(RangeSum(ABOVE(SUM({1<KPI_NAME={'$(vKPIChecking)'}, MONTH=>} COMBO_NEW_GOAL_VALUE), 1, MONTH-1)), MONTH))
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
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))
have you tried the below
aggr(only({<MONTH>}RangeSum(ABOVE(SUM({1<KPI_NAME={'$(vKPIChecking)'},MONTH=>}COMBO_NEW_GOAL_VALUE),1,MONTH-1))),MONTH)
Hi Vineeth,
Thanks for the reply. Yes I tried your approach and it doesn't work...
Any other ideas please?
Still filtering on month...
Not sure what's going on...
How do you define vKPIChecking?
vKPIChecking= 'New Checking Accounts'