ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Pivot Table Layout (https://www.excelbanter.com/excel-programming/296566-pivot-table-layout.html)

Todd huttenstine

Pivot Table Layout
 
Hey guys

I have a pivot table that is has the following layout:

PageFields: Department, Manager, Supervisor
RowFields: Employee Name
ColumnField: NOTHING
DataField: Percent Overdue, Follow-Ups Ontime, Total
Follow-Ups

I want the datafields to be displayed going accross from
left to right. Instead they are listed Vertical.

Now I have another pivot table that has the same layout
and its datafields are going left to right. Why is this
Pivot Table any different? Please tell me how to get the
datafields to go left to right like my other pivot table.



Thank you

Hans

Pivot Table Layout
 
Does it help if you drag the DATA field to the Total
column?

regards
-----Original Message-----
Hey guys

I have a pivot table that is has the following layout:

PageFields: Department, Manager, Supervisor
RowFields: Employee Name
ColumnField: NOTHING
DataField: Percent Overdue, Follow-Ups Ontime, Total
Follow-Ups

I want the datafields to be displayed going accross from
left to right. Instead they are listed Vertical.

Now I have another pivot table that has the same layout
and its datafields are going left to right. Why is this
Pivot Table any different? Please tell me how to get the
datafields to go left to right like my other pivot table.



Thank you
.



All times are GMT +1. The time now is 09:08 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com