Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivottable total cloumns
I have created a pivotable and I would like to have more than one type
of data in the total column(Qty, AUP, Total). The problem is that when I add more than one item to the total column in the pivottable, it stacks the data rather than creating more columns side by side. Is there a way around this? Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivottable total cloumns
What you need to do is drag the field label with the data
to your right and this will create the columns that you need. Just play with the field labels on the table and you will see how it changes. Andres -----Original Message----- I have created a pivotable and I would like to have more than one type of data in the total column(Qty, AUP, Total). The problem is that when I add more than one item to the total column in the pivottable, it stacks the data rather than creating more columns side by side. Is there a way around this? Thanks . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
PivotTable Grand Total Error using Calculated Field | Excel Worksheet Functions | |||
Data merging from two cloumns into one | Excel Discussion (Misc queries) | |||
PivotTable - Percent of Current Total | Excel Discussion (Misc queries) | |||
how to seperate cell contents into two cloumns ? | Excel Discussion (Misc queries) | |||
PivotTable-% of total | Excel Worksheet Functions |