Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How to have multiple columns in pivot table data area?
I have a pivot table that has the following columns Username, Data, Total For each occurrence of username I have inserted to the data area 2 fields, total number of jobs submitted and the total duration of those jobs. The resulting table shows 2 rows per username with the correct results and with the field name repeated over and over, what I want is to display the results as a column each with the field name as the column header. How do I do this? regards Mitch -- mitch1962 |
#2
|
|||
|
|||
To arrange the fields horizontally, drag the Data field button onto the
cell that contains the word 'Total'. There are instructions with pictures he http://www.contextures.com/xlPivot02.html mitch1962 wrote: I have a pivot table that has the following columns Username, Data, Total For each occurrence of username I have inserted to the data area 2 fields, total number of jobs submitted and the total duration of those jobs. The resulting table shows 2 rows per username with the correct results and with the field name repeated over and over, what I want is to display the results as a column each with the field name as the column header. How do I do this? regards Mitch -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need Formula to display pivot table source data | Excel Worksheet Functions | |||
How can deleted data reappear in a refreshed pivot table in Excel | 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) | |||
Pivot Table combining multiple columns | Excel Discussion (Misc queries) |