3 Replies Latest reply on Feb 6, 2019 1:47 PM by Craig Mullins

    average customer age by year asterisk issue

    Craig Mullins

      how can I prevent repeat customers from only appearing in an asterisk "*" column?

       

      for example

      • customer A buys in years 1 and 3
      • customer B buys only in year 2
      • customer C buys in years 1, 2, and 3
      • customer D buys only in year 2

       

      only the average for year 2 appears -average age for B and D.

      customers A and C fall under column "*"

       

      perhaps a LOD calc/

       

      thanks