I have an expression in a Pivot chart with Year Month Dimension as below, it doesnt work and I am unable to find the issue with this:
I am trying to aggregate the monthly values for Year To Date numbers, which are stored in variables as seen here.
Thanks in Advance for your help
Aggr will only group information by the dimensions you choose.
You need to do something with the results.
Thank you for the quick response, I was actually trying the same expression as mentioned by all of you here. But the problem is the 2 variables when combined give me a number and its the same even when I am doing the AGGR.
Both these expressions when used on a Pivot with Calendar.YearMonth as dimension gives me the same result. I was expecting the second one to display the carryforwarded totals from the last month. The first expression shows me the number for the Moth to Date collection and I want the second one to total it and shows Year To Date... How is it possible??
I tried this expression as well, but it doesnt seem to work atall...
Here is what I am trying to do:
$(vActPrinCashFlowC)+$(vActIntCashFlowC) Using this expression gives me
sum(AGGR($(vActPrinCashFlowC)+$(vActIntCashFlowC),Calendar.YearMonth)) Using this expression I want to
I thought AGGR does it for me... but no...please help
I tried all the above expressions and nothing works for me. The strange thing is that when i convert my Pivot into a Bar chart to check i the Full Accumlation works... then its solves my problem. Can you tell me how to do a FULL ACCUMLATE of values in a Pivot please?
Above and Below are the comparable functions within a pivot table, used with rangesum I believe it will get you on your way, here is a brief example, just replace Sales with your variables.