Nothing simple. You have to copy the values out of the pivot table and
manipulet them in a regular sheet. You could do it with code and the code is
not too wild and crazy (not exactly simple but very doable).
--
HTH...

Jim Thomlinson


"DavidHawes" wrote:

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