Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a Pivot Table with Revenue per year/portfolio/accounts and I would like, on top of the sum of Revenues, to have an expression with the cumulative sum of revenues over the years starting in the first year displayed in the Pivot Table. I am going with the Full Browser version of QV, and a Pivot Table has got no Accumulate option for expressions.
'
I have tried with the Expression below:
but this is not working. I also tried replacing Before() with above(), same result. Pivot Table looks like this (hidding the data)
I suspect the problem is linked to dealing with NULL(). Maybe the syntax of expression also is not good. I think what I want to do is quite basic, could someone help ?
Thanks
I tried with
AGGR(Rangesum(Before( TOTAL Sum(Revenue), 0, ColumnNo(TOTAL))), [Year])
as the sum is over columns (Year). Could you help me for this ?
I have some more precise questions:
* What should be the second term in AGGR() ? Should it be the dimension I want to sum over (Year), or the other dimensions for the pivot table, such that I want a cumulative sum for each of the cells defined by these dimensions (Portfolio, corporate account, billing account...) ?
* What is the syntax to say that I want to sum over years ?
Thanks in advance