How can I group data by columns as well as rows?

[Motox]

Hi,

I need to be able to group items that run along the top of my Pivot Table as well as those that run down the rows.

I don't seem to be able to do this.

I have a spreadsheet for recording daily if an inspection form has been handed in for Light Vehicles (LV007, etc).

I have dates running down and the LV's running across the Pivot Table. I can filter dates to show weeks but also need to be able to filter the LV's by the Departments they belong to.
I would like to use Department in the Report filter so that I can display, for each Department, which LV's have or have not been inspected for the week (see the Department Tab in the attached spreadsheet).

How can I set up my spreadsheet to be able to get a Pivot Table to do this?

Thanks very much

Dave

[xlbiznes]

Hi,

Why don't you simply created a calculated field to calculate the total for each department in the Pivot table , like this :


For Administration it would be : LV007+LV019

[Motox]

Hi,

I don't really want the totals. I want to see which days have/have not had an inspection for each vehicle for each department. I really want to filter for a whole week for a given department, then send that table to the Department Manager to give the manager an overview of the inspection compliance.

Thanks very much

Dave