SAS Office Analytics, SAS Add-In for Microsoft Office, and other integrations

Office Analytics - Calculating Average using two fields in pivot table

Reply
Contributor
Posts: 42

Office Analytics - Calculating Average using two fields in pivot table


I imported data in Excel Office Analytics as a Pivot table.

In the Pivot Table I added the Amount Fields twice and changed the one to Count and the other to Sum e.g.

1. Count of Records (Total Records)

2. Sum of Paid Losses (Sum)

How would I determine the average using the above?

Sum of Paid Losses (Sum) / Count of Records

Not sure how to use the fields above to set up and write the formula.

Ask a Question
Discussion stats
  • 0 replies
  • 271 views
  • 0 likes
  • 1 in conversation