Pivot table for two different data variables

  • Thread starter Thread starter comp
  • Start date Start date
C

comp

I have the following table


Name type Cost overhead
amy C1 23 12
bob C2 129 17
cat C2 36 45
doo C2 100 32


I owuld like to create a pivot table that looks similar to:
the standard pivot table. (Please ignore type for now.)

name Data Total
amy Sum of overhead 200
Sum of cost 12
bob Sum of overhead 130
Sum of cost 23
cat Sum of overhead 90
Sum of cost 19
doo Sum of overhead 87
Sum of cost 34
Total Sum of overhead 507
Total Sum of cost 88



But with overall total (overhead + cost) for each
individual instead of total the two types separately.
Any help would be totally appreciated.
Thanks,
pac
 
Hi

to create a calculated field in your pivot table, select a cell in the pivot
table and choose from the pivot table icon on the pivot table toolbar -
formulas - calculated field
give it a name
then after the = sign
double click on the cost field
type a +
the double click on the overhead field
then click on Add then OK
you can now hide the cost & overhead fields if you want

Cheers
JulieD
 
You could add a column to the source data, and calculate the total
there. Add that field to the pivot table, and remove Cost and Overhead.
 
Back
Top