Help with displaying summary please...

D

Dharmy

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
 
M

Max

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula to count multiple various inputs and create a summary 2
Displaying zeros in a report? 2
Need to report a count that meets multiple criteria. 2
Need help with a formula! 3
Excel formula to convert decimals to time 2
Excel files - macros & links 4
Counting repeated occurances 2
Storing Multiple Selected Pivot Table Report Filter Values 2

Top