Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Experts,
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.
=AGGR($(vActPrinCashFlowC)+$(vActIntCashFlowC),Calendar.YearMonth)
Thanks in Advance for your help
Ma
Hi,
is it possible, that you want to sum the values? than try this:
=Sum(AGGR(($(vActPrinCashFlowC)+$(vActIntCashFlowC)),Calendar.YearMonth))
Greetings from Munich
Aggr will only group information by the dimensions you choose.
You need to do something with the results.
E.g.
sum(AGGR($(vActPrinCashFlowC)+$(vActIntCashFlowC),Calendar.YearMonth))
or
avg( AGGR($(vActPrinCashFlowC)+$(vActIntCashFlowC),Calendar.YearMonth))
Regards,
Erich
Hi,
Can you pls try using the following:
=AGGR(sum($(vActPrinCashFlowC))+sum($(vActIntCashFlowC)),Calendar.YearMonth)
Regards
Arun
Hello All,
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.
$(vActPrinCashFlowC)+$(vActIntCashFlowC)
sum(AGGR($(vActPrinCashFlowC)+$(vActIntCashFlowC),Calendar.YearMonth))
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??
Thanks Again,
Hello Arunraj,
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
2011-01 20,000
2011-02 33,000
2011-03 41,000
sum(AGGR($(vActPrinCashFlowC)+$(vActIntCashFlowC),Calendar.YearMonth)) Using this expression I want to
2011-01 20,000
2011-02 53,000
2011-03 94,000
I thought AGGR does it for me... but no...please help
Thanks
Hi,
you need the function before resp. above
Hello Martina,
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?
Thanks Again
Hello All,
Do we have an option to do a full Accumlate on a Pivot table like we can do it in Straight Table and other Charts??/
Thanks in Advance,
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.
rangesum (sum(Sales),below(sum(Sales),-1,11))