Divide Running Total Columns in Pivot Table

[MCTampa]

I have a pivot table with two running total columns.
I would like to divide one column by the other to create a running average.

After much searching I cannot find a way to do this. Simply creating a calculated field doesn't work.
I was able to do this in Tableau a few years ago, but I'm not sure Excel can aggregate data the same way.

Thanks for any help

 

[MCTampa]

Weird...I've spent a day researching this and haven't found a solution. I would think this functionality would be native to Excel, but it appears to not be.

 

[SpillerBD]

Tableau compares to PowerPivot. Using PowerPivot and it's DAX language, you can create the calculation.
The hard part is often having the right version of Excel.... see What is Power Pivot? - PowerPivotPro
You'll notice this forum has its own PowerBI group.
If you do have access to PowerPivot, you might check out Mike Girvin's YouTube Channel (ExcelIsFun) for a fast start.

There is also a method of using the free PowerBI for Desktop. Power BI | Interactive Data Visualization BI Tools

 

[MCTampa]

I just installed PowerPivot and am working with it now.