| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot table organizing
Is it possible to have the pivot table group text fields in the same row? I
have a total of 3 colums of data, but one column has a unit name, and one column that has the description of the unit name. When creating a pivot table, it automatically puts the description in the row below the unit name. I woudl like for the Unit Name and Unit Description to be in the same row, but in different columns. Thak you for any assistance. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pivot table organizing
Hi,
Yes, If you are using 2003 or earlier you probably want to suppress the subtotal rows for the left hand row field - to do that double click the left hand row field button and set the Subtotals to None. If you are using 2007 then you probably want to switch layouts - with the pivot table selected choose PivotTable Tools, Design, Report Layout, Show in Tabular Form. If this helps, please click the Yes button. -- Thanks, Shane Devenshire "jim" wrote: Is it possible to have the pivot table group text fields in the same row? I have a total of 3 colums of data, but one column has a unit name, and one column that has the description of the unit name. When creating a pivot table, it automatically puts the description in the row below the unit name. I woudl like for the Unit Name and Unit Description to be in the same row, but in different columns. Thak you for any assistance. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pivot table organizing
I did forget to mention I was using 2007. I used your suggestions and works
perfectly. Thank you again. "ShaneDevenshire" wrote: Hi, Yes, If you are using 2003 or earlier you probably want to suppress the subtotal rows for the left hand row field - to do that double click the left hand row field button and set the Subtotals to None. If you are using 2007 then you probably want to switch layouts - with the pivot table selected choose PivotTable Tools, Design, Report Layout, Show in Tabular Form. If this helps, please click the Yes button. -- Thanks, Shane Devenshire "jim" wrote: Is it possible to have the pivot table group text fields in the same row? I have a total of 3 colums of data, but one column has a unit name, and one column that has the description of the unit name. When creating a pivot table, it automatically puts the description in the row below the unit name. I woudl like for the Unit Name and Unit Description to be in the same row, but in different columns. Thak you for any assistance. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to create pivot table from existing pivot table in excel 2007 | Excel Discussion (Misc queries) | |||
| Filter lines with Pivot table and non pivot table columns | Charts and Charting in Excel | |||
| Pivot table and organizing data | Charts and Charting in Excel | |||
| Help organizing data 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 | |||
Linear Mode
