PIVOT calculation.. ?
 

Hi all, hope you can help.

I have the following pivot:

Apples ApplesTotal Pears
PearsTotal
QTR NoSeed WithSeed NoSeed WithSeed
Q1 638 2007 2645 611 1423
2034
Q2 662 1690 2352 619 1588
2207
Q3 742 2131 2873 895 1648
2543
Q4 403 1545 1948 244 557
801
2445 7373 9818 2369 5216
7585

When it is just Apples & Pears, I can do a calculated formula as I can see
both items in the dropdown list. But, when I try to a calculated formula on
the subsets (NoSeed, WithSeed) they do not appear.

What I've been asked is to show are the following:
2445/(2445+2369)
7373/(7373+5216)
9819/(9819+7585)

While I can do these outside of the Pivot, inside would be better, as it is
a very large pivottable, and as people make their own selections, my outside
calculations would become meaningless. Hope I've not gone on too much...

Thanks for your inputs.

Rgds.,
John.