Hi there

I need some help with a work report. I tried pivot tables but am surely
doing something wrong. I have the following data in a sheet:

Item Priority Status
a Critical Open
b Critical Open
c Critical Reopened
d Critical Closed
e Medium Open
f Medium Open
g Medium Reopened
h Medium Reopened

I would like to 'transform' the above to the following summary:

Critical
Open 2
Reopen 1
Closed 1

Medium
Open 2
Reopen 2
Closed 0

Any ideas?

Thanks in advance

Easiest to eke it out using a pivot ..

In step 3 of the pivot wizard, click Layout, then:
Drag n drop Priority in ROW area
Double-click on it, set Subtotals to None
Drag n drop Status in ROW area, below Priority
Drag n drop Status in DATA area (as COUNT)
Click OK Finish, and the pivot will return the core report that you seek
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:21,000 Files:365 Subscribers:65
xdemechanik
---
"Dharmy" wrote:
I need some help with a work report. I tried pivot tables but am surely
doing something wrong. I have the following data in a sheet:

Item Priority Status
a Critical Open
b Critical Open
c Critical Reopened
d Critical Closed
e Medium Open
f Medium Open
g Medium Reopened
h Medium Reopened

I would like to 'transform' the above to the following summary:

Critical
Open 2
Reopen 1
Closed 1

Medium
Open 2
Reopen 2
Closed 0

Any ideas?

Thanks in advance