Pivot Table - where to start with so many column headings from a

Hi Serena,

Thank you for your question and welcome to the forum.

Create the pivot table and add the following fields:

Page or Report Filer - Add the Department field.
Row Headings - Add Project and Tasks fields in that order.

Then add the whichever time field or fields you need to summarise as the data fields.

Go to the Pivot Table Tools menu and choose the Options tab. In the Pivot Table Group choose Options. Go the the Display tab and then tick the checkbox that allows Classic Pivot Table layout.

Now in the Page field you can choose a particular department.

Then click on the filter button on the Project field name and choose Value Filters. Choose the Top 10 option.

This result should you by department, which project, what tasks and the hours for each task on that project.

If you want to show the total hours for each Project for each department then you remove the Task field from the row headings.

Try that and let me know if it helps or worked.

Regards

Simon