8 Replies Latest reply: Aug 27, 2015 8:14 AM by Andrea Stecca RSS

    Loyal customer per years using indirect set analysis

    Andrea Stecca

      Hello,

       

      I' m try to have a pivot table whit my loyal customer by year with the sum of amount by years.

       

      my dimension are : Customer and Year

       

      my expression is :

       

      sum ( {<Customer=p({<Year={'<$(=max(Year))','<$(=max(Year)-1)'}>}Customer)>} sales)

       

      The problem is when i select year 2014 the pivot table not show me also year 2013

       

      See attchament

       

      Thanks in advance for your help


      Andrea