Pivot Table- Multiple Column Fields

[JennB]

I am struggliing to construct a Pivot Table with 3 Row fields and 2 or more sets of column fields. Every thing is fine with just 1 column field, but gets wonky when I try to add a second column field.

Example:
Row Fields = Region, Supervisor, Worker
Column Fields = Critera1 which contains text values: Compliant or Not Complaint
Data Field = Count of Case#

This gives expected results, Criteria1 with columns labeled Compliant, Not Compliant, Grand Total

But when I add a second Column Field: Criteria2 which contains text values: Current or Lapsed
I now get the confusing gridlike header columns labeled:
Compliant Current, Compliant Lapsed, Total Compliant, Not Complaint Current, Not Compliant Lapsed, Total Not Compliant, Grand Total

The pivot table is treating Criteria1 and Criteria2 like they are related, when in fact they are not.

What I want to see is 6 columns:
Compliant, Not Compliant, Total, Current, Lapsed, Total

Is there a way to do this?
I'm using Excel 2003.

 

[xenou]

Could you post some sample (or dummy) data - but from the sourcedata grid (the original data), not the pivot table. I could try to recreate the pivot table that way and see how it comes out for me. I've a vague notion you want to add a second data field, but I'm not sure how.

ξ