Pivot Table

H

hce

Dear All

My knowledge of pivot table is limited... so kindly help if possible...
Say if I have a column of data (Satisfaction Level) as the one on the
horizontal field (Y axis) of the pivot table and straight away, it will
show the different group of Satisfaction Level.

Sat Level has a range from 1 to 5 so there will be 5 columns... My
question is how can I include another two columns in the pivot table to
show the sum of 1 and 2 and the sum of 4 and 5? Is this possible?
Currently, I am doing the calculations manually... which is taking alot
of my time especially if there are many different groups in the "X" axis
of the pivot table.

Kindly suggest/advice whether this is possible...

Cheers
 
S

sp00nix

use a function, such as =sum(A1:B1) and =sum(D1:E1), then leaving you
functions on top, select everything below it until the end of you
pivot, and press CTRL+D to introduce the function to each selected row
 
H

hce

HI

Thanks for the quick reply... but i'm not really sure what you ar
referring to... could you kindly explain a bit more in details..? bt
so it is not possible to do that in pivot huh...?

cheer
 
Top