ExcelBanter - Pivot Table Data

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Pivot Table Data (https://www.excelbanter.com/excel-worksheet-functions/181887-pivot-table-data.html)

lotivbarjoh

Pivot Table Data

Hi,

I have a pivot table with three fields of data that are totaled by
Product Line. I need the Total Data fields which are listed as rows to
be listed as columns, how do I swop them?

Can anybody help.

Roger Govier[_3_]

Pivot Table Data

Hi

Drag the Data button and drop in on Total in the PT.

--
Regards
Roger Govier

"lotivbarjoh" wrote in message
...
Hi,

I have a pivot table with three fields of data that are totaled by
Product Line. I need the Total Data fields which are listed as rows to
be listed as columns, how do I swop them?

Can anybody help.

All times are GMT +1. The time now is 05:37 PM.