Nested Pivot Table

[Trevor Aiston]

Sorry about the subject title but only way I could think to describe my
question,

I mainly work with clinical data so frame my question with that.

If i have a worksheet containing case notes which had colum headings of
diagnosis
gender
town
I want to summarise the data by creating a pivot table with
diagnosis lables as rows
town labels as colums each town colum divided by male/female
gender
with a count of diagnosis in the table.
I can create a simple table with either town or gender as colum hedings but
not nesting one under the other.

Any suggestions?

TIA

Trevor
Diagnosis

 

[Debra Dalgleish]

In a pivot table you can put:
-Diagnosis in the Row area
-Town and Gender in the Column area
-another copy of Diagnosis in the Data area, where it will be shown as
"Count of Diagnosis"

That should give you the results you want.