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

    Loyal customer per years using indirect set analysis

    Andrea Stecca



      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