Pivot Table Summary

[arunsharm82]

Hi,

I want to be able to summarise some data that I have in a Pivot Table
created.

The data from the Pivot Tables is contained in many tabs in m
workbook. I just selected the mutliple sources option when I create
the table, using the wizard.

It has people names in the rows and the programs they worked on in th
columns. The data in the table is the amount of time a person ha
worked on a program.

I would like to know if it is possible to summarise all the data b
each person's name and then an individual line for the each progra
they worked on and the amount they worked on it. (and ignore th
programs they didn't work on)

i.e.

Arun Sharma - BMW program - 0.5
Arun Sharma - VW program - 0.2
Arun Sharma - SMART - 0.3

Is this possible?

I would appreciate any help or advice as soon as possible.

Thanks in advance
:

 

[Debra Dalgleish]

Pivot tables are somewhat limited when created from multiple
consolidation ranges. There's an example here:

http://www.contextures.com/xlPivot08.html

You'd have the most flexibility in your report if you store all the data
on the same worksheet, with Name, Program, Hours as column headings, and
any other columns you need, e.g.

Name Program Hours Date
Sam ProgramA 15 7/1/04
Joe ProgramB 20 7/1/04

Then, create the pivot table from that, with Name and Program in the Row
area, and Hours in the data area. It would omit any programs on which
the person didn't work.

 

[arunsharm82]

Thanks Debrah much appreciated..