topic Re: caliculate sum formula in pivot table in QlikView

caliculate sum formula in pivot table

surendraj — Sat, 16 Nov 2024 04:29:00 GMT

Hi Guys,

I have a requirement where my values are in pivot table

date April 1 May 1

Type count value total count value total whole total

Type 1 3 5 15(3*5) 3 4 12 15+12=27

Product Type 2 4 6 24 4 7 28 24+28=52

Please suggest me how to caliculate that whole total value in my pivot table..

--Surendra

MindaugasBacius — Tue, 12 Feb 2019 08:33:29 GMT

This might help:

surendraj — Tue, 12 Feb 2019 08:54:55 GMT

No it is giving full total..by row wise.

and we have also several expressions in expressions tab.

That whole total value should came(pick) from each date wise.

juliensaintmaxent3113 — Tue, 12 Feb 2019 10:58:53 GMT

Hi,

I think you must calculate each values with set analysis per month and on the last the cumul with the function column.

Sum({$<Month={'April'}>value)

Sum({$<Month={'April'}>Volume)

Column(1)*column(2)

etc

you can automatise the value of the month also.

Bye