Cumulative sum by column

[fatihtomruk]

Hi all,

I want to make Balance Sheet on qlikview. But BS must be cumulative, not be single month.

Not like this. Because jan is correct but feb and the other months is montly, must be cumulative.

It must be like this.

Could you please help me?

Fatih Tomruk.

[fatihtomruk]

rangesum( above( sum([Tutar (UPB3)]),0,12) )

This formula is true when months on row but when put it on column, it is not true.

[uacg0009]

Hi Faith,

Actually in Chart Properties, there is a function - Accumulation.

You can try to use Full Accumulation. And for expression, just use sum() is ok.

Please try, thanks.

Aiolos

[fatihtomruk]

Thanks Aiolos, but this is not for pivot or straight table.

When choose pivot table, this property is deactive.

[uacg0009 · Accepted solution]

Hi Faith,

Yes, you are right, if you use pivot table, I think you can use this :

RangeSum(First(sum([Tutar (UPB3)]),1,ColumnNo()))

Thanks.

Aiolos

[fatihtomruk]

Thanks Aiolos, it works

[pk]

what is [Tutar (UPB3)]???