Hi everyone

I've got a PivotTable which counts information that is split down into years and categories. I'd like to work out the proportion of the categories for each year and am unable to do this.

I've edited the field and changed the 'Show data as:' to '% of total'. However, this shows the splits as a proportion of all the data. What I'd ideally like is a '% of sub-total', but such a thing doesn't seem to exist.

Does anyone know how I can do this? I'm running Excel2000.

Any help much appreciated, kind regards

Nick