Thanks for this, but it only goes part of the way to solving my problem.
I need to calculate the percentage of one running sum column to another
running sum column.

Based on your example I have the 2 running sum columns. Now I need to insert
a calculated field with the following formula: RunningSum1 / RunningSum2.

The problem is that RunningSum1 and 2 are not available in the dialog box
for creating the calculated field. Only the "base" fields can be selected.

Do you know how to achieve this?
"Roger Govier" wrote:

Hi

Assuming you have two fields, Name and Amount.
You have Name as a Row field, and Amount as a Data field.
Drag the Amount Field to the Data area a second time. Double click on it
and choose Options.
In the dropdown for Show Data as, choose Running Total and select Name
as the base field.

If you want the two columns to show side by side, drag the Data button
on the PT to the Total area.

--
Regards

Roger Govier


"Dimitri" wrote in message
...
I wish to add a column in a pivot table that is a running calculation.
That
is, it uses values from the previous row and values from the current
row. Is
there any way to do this?