View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
toast88 toast88 is offline
external usenet poster
 
Posts: 5
Default Pivot Table Help

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