Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
column in a pivot table
I want to make a pivot table that has the company down the side and in the
colums i want the company premium in one column and the other company commission. When i put the premium and commission it puts the info there but they are on top of each other. I want to have the information in separate columns. company Premium Commission company Premium Commission company Premium Commission Thank You, Julie |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
column in a pivot table
If I understand you correctly you have the data in rows and you want it in
columns? That is the default behaviour when you drop a second field into the data section. Assuming that to be the case then all you need to do is to drag and drop the data fields from the rows to the columns (Grab the field names and move them)... -- HTH... Jim Thomlinson "Julie" wrote: I want to make a pivot table that has the company down the side and in the colums i want the company premium in one column and the other company commission. When i put the premium and commission it puts the info there but they are on top of each other. I want to have the information in separate columns. company Premium Commission company Premium Commission company Premium Commission Thank You, Julie |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table - how to add column on the same row | Excel Worksheet Functions | |||
Pivot Table column appear as 0 | Excel Discussion (Misc queries) | |||
Sorting a Pivot Table Column that is not the first column... | Excel Worksheet Functions | |||
Pivot Table - how do I add a column? | Excel Worksheet Functions | |||
Pivot Table Row/Column | Excel Discussion (Misc queries) |