Pivot tables vs source data - ordering columns? | Excel forum

Hi Sally

Thank you, I have received your file.

Hours Spent Tab
•Months are not in order
-Right click on the month column heading and select sort > A-Z


Project Totals Tab (some columns hidden)

•The project budget isn’t showing so I have added it in as a field, but it then repeats throughout - would be good to get rid of the repeats so don’t have to hide it each time
–I couldn’t find a Project Budget Field. Which column is this in?

•Project budget column should appear after Total Profit (D)
-Do you mean the very last column of the Pivot Table (i.e. Total Sum of Total Project Budget)?

•Need to reorder the spent/charged/recovery columns to that order, for each dept (Staffing, Production, Account Handling, etc.)
-Use the Field List to reorder the columns (activate this by selecting the Pivot Table > Analyse Ribbon > Field List). You can either click on the field and select move up or down, or you can click and drag the field above the field it should go to.

-There is a strange sum of hours charged column appearing at the start of each dept – don’t need this
–Right click on the field and select remove field

Please let me know if that resolves your problems?

Thank you

Kind regards
Wendy