Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how to create pivot table from existing pivot table in excel 2007 | Excel Discussion (Misc queries) | |||
Pivot Table - Use Other Pivot Table as Data Source | Excel Discussion (Misc queries) | |||
Pivot Table Question : If statment in Pivot Table?? | Excel Discussion (Misc queries) | |||
pivot table: create worksheetsheet using pivot table | Excel Discussion (Misc queries) | |||
How do I create a pivot table if the pivot table icon or menu ite. | Charts and Charting in Excel |