Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
help please
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.
I should make sums for them
i should show three partial sums
and a total for all those
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.
use Column(1)+Column(2) or label of the column
Like wise you can sum as per yoour wish