Pivot Table Help

[Guest]

Hi Folks,

I am trying to set up a pivot table to allow me to sum / format a report
with indicative data by Month.

I have staff entering data in a sheet that is in the following format:

Indicative Data (column a - D); Months January - December in next 12 columns
TeamA Yes Stuff Junk 1 1 3 1 4 1 1 7 1 1 2 1
TeamB No Stuff Good 1 2 2 1 2 1 3 6 3 1 2 3
TeamA No Stuff Junk 1 1 3 1 4 1 1 7 1 1 2 1

How do I get the Months organized with headings (column e -...) at the top
of the pivot table and summed values in the report?

Sorry if this is simple and I am having a brain cramp.

Thanks,
Don

 

[Guest]

Your source data is not well organized for a pivot table. A better
organization would be...

This | That | AndThe | Other | Month | Value
Team A | Yes | Stuff | Junk | Jan | 1
Team A | Yes | Stuff | Junk | Feb | 1
Team A | Yes | Stuff | Junk | Mar | 3

Based on your current format you will need to create a caclulated field in
the pivot table which is Jan + Feb + Mar +... So you will add each individual
month to the pivot along with your calculated field. That still will not be
ideal but is should work.