Average of two columns in pivot table

Posting this for a friend.

I have data in a pivot table. One column is a sum of data. The other is the average of the data. I want the result of the sum divided by the average. I’m not sure how to construct a formula to do this.

I am not able to add an attachment of an excel file that shows what I am trying to do. Sorry if this violates rules, but here is a link to the file in my dropbox.

https://www.dropbox.com/s/irga3mntt7...blem.xlsx?dl=0

Any help very much appreciated.

Attached is a much scaled-down version of the requirement. Columns A:C are the data. Columns F:H is a pivot table built from the data. So far, everything is normal.

Then I overlaid a named dynamic range over the results of the first pivot table. Pivot_Data =OFFSET(Sheet1!$F$1,0,0,COUNTA(Sheet1!$F:$F),3)

For more information on named dynamic ranges, see: Pivot_Data =OFFSET(Sheet1!$F$1,0,0,COUNTA(Sheet1!$F:$F),3).

Then I used this named range as the data source for the pivot tables in columns J:M. Column M is a calculated field in the pivot table: ='Sum of Value'/'Average of Value2'

I left the column headers on the first pivot table exactly as they came out.

Given that you have office 365, you can load the data to the model, then use Power Pivot to create three measures. One is the sum of the Pay field, one is the Average of Weekly Sales and the third is simply the first measure divided by the second.