5 Year Average

[tmumaw]

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

[vvira1316]

Having only above information will not help to help you. Can you please share your application if you can or at least share more detail mocked data

[tmumaw]

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.

[dplr-rn]

May need to use a valuelist for each of the years rather than a simple dimension. And use it along with before function

https://community.qlik.com/t5/QlikView-Documents/Missing-Manual-Before-and-After/ta-p/1488064