Excel Table Question

[OM]

I have a table of data, 3 columns

Date Type Business Unit
01Jul 06 FAC NP
05 Jul 06 FAC BU5
11 Jul 06 MTC BU3
14 Aug 06 FAC BU3
16 Aug 06 MTC BU1
22 Aug 06 NWR NP
23 Aug 06 NWR NP
25 Aug 06 FAC BU1
etc.

The output I want is a table for each Business Unit, as below

BU1 FAC MTC NWR RWC LTC Total
Jul 06 2 1 0 0 0 3
Aug 06 2 1 2 0 0 5
and so on

This seems to me to be something ideally suited to a pivot table, but how do
I aggregate the entries into months ? When I do a pivot table, I get one
line for each date, rather than each month.

Thanks,

Rob Lepper

 

[Bob Phillips]

Build the pivot table, and setup the date in the pane, and then right-click
the Date header. You will then see a Group and Outline option, which if you
click this, then you will see an option to group by Months.

HTH

Bob