Hi,

I've produced a pivot table to count the number of patients waiting in
various groupings. As excel nicely does, it's supressed repeated values when
there are more than one sub-categories within a main category...

e.g.

Sub heading Weeks Wait No. of Patients
Colonoscopy 0 25
1 20
2 15
3 6

Is there a way I can tell the pivot table to show "colonoscopy" on every row
rather than supress the repeated value? I can't seem to find an obvious way
of doing it.

Any help would be great.

Cheers,

David