Accumulated Column

[martino]

By using "Above" in a formula as shown here:

Sum(Sales) + if (rowNo()=1,0, Above([Column Name]))

I have created an Accumulated column

It works perfectly as long i only have 1 Dimension column, but when I have 2 or more dimension columns I can't get the the formula to work.

Does anyone have som insight on this?

Best regards

Martin

[kaushiknsolanki]

Hi,

     Try this.

     Go to expression and click on the expression for which you want accumulated value and select the Full Accumulation at the left bottom corner.

Regards,

Kaushik Solanki

[martino]

Hi Kaushik,

Thanks for your suggestion, but unfortunately it is not good enougt to use the "Full Accumulation" function under properties as I have a colunm to the right of the Accumulated column that validates the accumulated value and based on the value shows an A, B or C. That does not work when I use the "Full Accumulation" function.

/Martin