04-26-2013 09:00 AM
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.