ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   format pivot table (https://www.excelbanter.com/excel-worksheet-functions/99851-format-pivot-table.html)

confused

format pivot table
 
Hi,

I have a pivot table which has project names in the first column, and 'sum
of month' in the 2nd column (e.g 'Sum of Jul', 'Sum of Aug', 'Sum of Sep' for
each project.) Then it has the totals for each month in the 3rd column.
How can I change the layout of the table so that rather than having the 'sum
of' appear as a column, it displays as a row, with the totals in a second row.
So there will be one row with the headings 'Sum of jul', 'sum of aug' etc,
then each project will have a row with totals in it

thanks for any help


All times are GMT +1. The time now is 04:54 PM.

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