Accumulation in PIVOT with 3 dimensions

[ziabobaz]

Hi!

I am trying to calculate running totals in Income Statement.

I managed to do so, but the problem is that the result is located on the level of 3d Dimension, whilst my running totals should be on the level of 1st Dimension. Is it possible to move it like I showed with green arrows?

Is it also possible to hide 2d and 3d Dimension levels in my running totals (gross profit and pre-marketing margin)?

if([PL_Раздел]='Gross Profit' OR [PL_Раздел]='Pre-Marketing Profit',

rangesum(above(total sum(  Сумма),0,rowno(total))),

sum(  Сумма)

)

)

[JordyWegman]

Hi,

I don't think this is possible the way you want. This is because Qlik does not offer these functionalities. You can try the Climber Finance Report in a trial. This gives you the possibilities you need and a lot of customizations.

Jordy
Climber

[ziabobaz]

Hi

I ended up with the following workflow
https://community.qlik.com/t5/Qlik-Design-Blog/How-IntervalMatch-Solved-My-Profit-and-Loss-Dilemma/b...

Tried Climber Finance report, but it's overly complicated (at least for me).

Also in June'19 Qlik Sense update a new PL extension is introduced, I am gonna give it a try.

Thank you