Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

how to make three sums in one pivot table

I am hvaing a filed which consists of 20 columns in it for example

a

b

c

d

e

f

g

h

i

in this I have to make Sum for a b c

for that i should name total

and again i should make sum for total+d= compensation

the last step i should sum for all compensation+efghi

i am trying to create inline table but it is not working any ideas

5 Replies
Not applicable
Author

help please

Not applicable
Author

Hi,

You can solve this by adding a field to your data model with the desired groups. Then use the new field in the pivot table.

current_field    new_field

a                    a

b                    b

c                    c

a                    total

b                    total

c                    total

a                    compensation

b                    compensation

c                    compensation

d                    compensation

...                   ...

Hope this helps.

Not applicable
Author

I should make sums for them

i should show three partial sums

and a total for all those

Not applicable
Author

Pivot Tables can handle only one partial sum per field.

This is what I mean, without using partial sums. Additional conditional formatting could be added.

sivarajs
Specialist II
Specialist II

use Column(1)+Column(2) or label of the column

Like wise you can sum as per yoour wish