Dividing columns in straight table when values have been accumulated

[NickBentley]

I have used the full accumulation button to calculate YTD sales by month for a number  of years.

I understand that when I then divide my these columns to work out the growth, the calculation divides the non-accumulated figure rather than the accumulated figure that appears in the table columns. 

I was wondering if there was a work around for this?

Thanks

Nick

[QFabian · Accepted solution]

Hi @NickBentley , one option can be create the accumulation in the expression, for example :

exp1 or column(1), first aggregation  : sum(Data)

exp1 or column(2), first aggregation  but totalized : sum(total Data)

exp2 or column(3), for simple acummulation : sum(Data)  + previous(sum(Data))  or can be sum(Data)  + previous(column(1))

exp3 or column(4), % : column(1)/ column(2)

those are a few posibilities, you can create more.

[NickBentley]

Thanks QFabian!

Tried it on my file and worked a treat.

Cheers