I’m trying to accumulate some values inside a Pivot Table (so I can use horizontal dimensions). The challenge is that I need to accumulate month by month only certain values whilst using non-accumulated values for the second part of the expression.
I’m attaching a sample file in which the example will become clearer.
From what I'm seeing, it looks like you can't do it in one expression. In my attached file, when I calculate the accumulation of A and just the sum of B in two different expressions, then add those two together, it works fine. The problem comes in when I try to put the two expressions into one. Maybe someone else can chime in if they have any ideas because I'm stumped .
EDIT: I forgot to mention that the 1,12 in the before() is accumulating 12 steps back (1 year), as I wasn't sure on your exact requirement. If you want to accumulate over everything, replace the 12 with ColumnNo(TOTAL).