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


"comp" <(E-Mail Removed)> wrote in message
news:qCtwd.7700$E_6.5624@trnddc04...
>
>
> 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
>
>
>
>
>

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.

comp wrote:
> 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
>
>
>
>
>


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html