Hi There,

Thank you very much for your reply, it's very much appreciated.

I am trying to follow your suggestions but am not able to do it. I
think it may not be appropriate for my situation. I should have given a
better description of the problem in the first place, My Bad! So I will
try to explain it, properly this time.

Suppose my raw data looks something like this:
There are two variables X, Y each with four possible values xa, xb, xc,
xd & ya. yb. yc, yd

X    Y
xa    ya
xa    yb
xa    yc
xa    yd
xb    ya
xb    yb
xb    yc
xb    yd
xc    ya
xc    yb
xc    yc
xc    yd
xd    ya
xd    yb
xd    yc
xd    yd
.     .
etc

I create a Pivot Table to count the combinations of each X value with
each Y value:

Count of X    X
Y    xa    xb    xc    xd    Grand Total
ya    2    2    2    2    8
yb    2    2    3    1    8
yc    1    2    2    2    7
yd    1    2    2    2    7
Grand Total    6    8    9    7    30

Thus Column field is X, Row field is Y, and for the Data field I can
actually add either X or Y, though I have added X. The Data field is
Count of X

Next I want to add a Running Total of the Count so I add another
instance of X as a Data field and change "Field Settings" > Options >
"Show data as:" > "Running Total In" > Y. I get the Pivot Table:

        X
Y    Data    xa    xb    xc    xd    Grand Total
ya    Count of X    2    2    2    2    8
    Running Total of X    2    2    2    2    8
yb    Count of X    2    2    3    1    8
    Running Total of X    4    4    5    3    16
yc    Count of X    1    2    2    2    7
    Running Total of X    5    6    7    5    23
yd    Count of X    1    2    2    2    7
    Running Total of X    6    8    9    7    30
Total Count of X        6    8    9    7    30
Total Running Total of X

To this, I want to add another Data field Remaining Sum of X (as I had
described in my original post) for each Column. To make it even more
complicated, I actually need this number as a percentage of the total.
So the table with Remaining Sum would look like:

Y    Data    xa    xb    xc    xd    Grand Total
ya    Count of X    2    2    2    2    8
    Running Total of X    2    2    2    2    8
    Remaining Sum    4    6    7    5    22
yb    Count of X    2    2    3    1    8
    Running Total of X    4    4    5    3    16
    Remaining Sum    2    4    4    4    14
yc    Count of X    1    2    2    2    7
    Running Total of X    5    6    7    5    23
    Remaining Sum    1    2    2    2    7
yd    Count of X    1    2    2    2    7
    Running Total of X    6    8    9    7    30
    Remaining Sum    0    0    0    0    0
Total Count of X        6    8    9    7    30
Total Running Total of X
Total Remaining Sum        6    8    9    7    30

So my question basically is about how to calculate the "Remaining Sum"
part of the pivot table, which as far as I can tell is not possible
with the standard options for the Pivot Tables. The simplest solution
would to have an equation like "Total Count of X" - "Count of X" (for
that particular Column/Row), but unfortunately it is not possible to
make references to the same Pivot Table from a Calculated Field
Formula.

I hope I did a better job of explaining it then the first time round!
Any help would be appreciated.

Many Thanks,

RG