Running Total Average in a Pivot Table

[MCTampa]

Good afternoon,

My data has two elements: Revenue Transaction Volume (RTV) and Net Revenue Amount (NRA). I am trying to solve for Average Weekly Rate (AWR).

In a standard pivot table, AWR is an easy calculated field: AWR = NRA / RTV
For example:

Date	RTV	NRA	AWR
7/30/2017	20	$500	$25.00
7/31/2017	15	$450	$30.00
8/1/2017	25	$500	$20.00

<tbody>
</tbody>

However I am trying to achieve the same result using the running total feature in a pivot table:

Date	RTV	NRA	AWR
7/30/2017	20	$500	$25.00
7/31/2017	35	$950	$27.14
8/1/2017	60	$1,450	$24.16

<tbody>
</tbody>

My problem is that I cannot get the AWR to perform it's function when I am using running totals. It appears to simply be calculating the appropriate AWR for that transaction date or line of data.

Is there a way to do this within a pivot table using running totals?

Thanks,
Mike