topic Re: Pivot Table Custom subtotal in P&L in QlikView

Pivot Table Custom subtotal in P&L

waszcma1 — Thu, 17 Sep 2020 23:39:32 GMT

Could you help me to add custom subtotal but based only on some part of the data?

In this example I would like to have subTotal which calculates total of SALES + total of DIRECT COSTS

How Can I achieve this ? is it possible?

Re: Pivot Table Custom subtotal in P&L

chrismarlow — Mon, 21 Sep 2020 19:14:55 GMT

Hi,

I am not sure you can get just a subtotal in that part of the chart, but you can add a calculated dimension similar to below that will at least show you the values;

Cheers,

Chris.

Re: Pivot Table Custom subtotal in P&L

waszcma1 — Mon, 21 Sep 2020 20:56:36 GMT

Good hit! , I forgot about customized dimension option because I am always avoiding it as it is really lowering report performance (but my data model is not so big)

Any way I have discover other options which allows me to create view like this:

To do so I have use this expression:

it works fine but I am not sure if this is the best approach. I am still testing it.

Re: Pivot Table Custom subtotal in P&L

waszcma1 — Wed, 07 Oct 2020 10:30:25 GMT

Confirm that the solution I have found works as I expected.
The only thing is that I had to create some DUMMY line with value 0 for the cumulative subtotal.