topic Re: Cumulative Sum in Qlikview Pivot Table in QlikView

Cumulative Sum in Qlikview Pivot Table

BabyyGurusamy — Tue, 29 Sep 2020 11:19:56 GMT

I have a pivot table with 3 dimensions (Year, Quarter, Month) and calculating cumulative sum of sales using below expression

RangeSum( Above(TOTAL Sum(Sales), 1, Rowno(TOTAL)))

Cumulative sum is working fine when dimensions are fully expanded and not giving correct result when its collapsed.

Do we have any workaround for this issue?

Anil_Babu_Samineni — Tue, 29 Sep 2020 11:22:14 GMT

@BabyyGurusamy can you show where it is showing with expand and collapse?

BabyyGurusamy — Wed, 30 Sep 2020 06:55:02 GMT

Please refer the attached screenshot.