I'm trying to create a 5 year average customer count report, however having a small issue trying to calculate the average. Here is a sample of what my pivot table looks like. Each of the years uses the following calculation Count(distinct([Sold To])) . The same sold to can be in multiple years that's why I can't do a straight count divided by 5. Here is what the pivot table looks like:
PC 2014 2015 2016 2017 2018
A 50 45 40 40 25
I need column at the end with total and average for the 5 years.