Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
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.
Thanks
Model is too large to share. All I am trying to do is sum the columns across and create an average for the 5 years.