MCTampa
Board Regular
- Joined
- Apr 14, 2016
- Messages
- 97
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:
<tbody>
</tbody>
However I am trying to achieve the same result using the running total feature in a pivot table:
<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
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