Pivot Table

  • Thread starter Thread starter hce
  • Start date Start date
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
 
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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot Table Calculation 1
Pivot table subtotals 2
Pivot Chart - Excel 2013 - Rotating Second and Third Lines of text onthe Horizontal Axis 0
Average of % in pivot table 1
Pivot table grand total location 1
pivot table data 2
Pivot Table won't Get 'r done 1
pivot table calc item 8

Back
Top