how to make three sums in one pivot table

[#1]

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

[#2]

help please

[#3]

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.

[#4]

I should make sums for them

i should show three partial sums

and a total for all those

[#5]

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]

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

Like wise you can sum as per yoour wish