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>
Date
RTV
NRA
AWR
7/30/2017
20
$500...