| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table Data columns
I recently created a pivot table with two fields in the ROW section and I put
five (5)fields in the DATA column. The problem is that all the five fields in the data section were put in one single column as rows. What can I do if I want 5 columns to show up in the DATA section. My final goal is to show 12 columns in the DATA section for the 12 months of the year. Can somebody help. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pivot Table Data columns
I am completely lost. Post some details, specifically what does your source
data look like and what does your pivot table look like... Copy and paste if that is feasable... -- HTH... Jim Thomlinson "Pele" wrote: I recently created a pivot table with two fields in the ROW section and I put five (5)fields in the DATA column. The problem is that all the five fields in the data section were put in one single column as rows. What can I do if I want 5 columns to show up in the DATA section. My final goal is to show 12 columns in the DATA section for the 12 months of the year. Can somebody help. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pivot Table Data columns
Drag the Data button onto the Total cell, as described he
http://www.contextures.com/xlPivot02.html Pele wrote: I recently created a pivot table with two fields in the ROW section and I put five (5)fields in the DATA column. The problem is that all the five fields in the data section were put in one single column as rows. What can I do if I want 5 columns to show up in the DATA section. My final goal is to show 12 columns in the DATA section for the 12 months of the year. Can somebody help. -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pivot Table Data columns
Debra,
THANK YOU very much.... "Debra Dalgleish" wrote: Drag the Data button onto the Total cell, as described he http://www.contextures.com/xlPivot02.html Pele wrote: I recently created a pivot table with two fields in the ROW section and I put five (5)fields in the DATA column. The problem is that all the five fields in the data section were put in one single column as rows. What can I do if I want 5 columns to show up in the DATA section. My final goal is to show 12 columns in the DATA section for the 12 months of the year. Can somebody help. -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Two columns of data in pivot table? | Excel Worksheet Functions | |||
| Grouping data in pivot table columns | Excel Discussion (Misc queries) | |||
| ? Pivot Table from 3 columns of raw data with headers | Excel Discussion (Misc queries) | |||
| Rearrange data columns in Pivot Table | Excel Discussion (Misc queries) | |||
| How to get pivot table data columns instead of rows | Excel Discussion (Misc queries) | |||
Linear Mode
