4 Replies Latest reply: Oct 3, 2011 1:21 PM by Marc Livingston RSS

    Selecting Low Activity Customers

      I am looking for an expression that will limit the results of a pivot table to customers that have not ordered anything in the past 3 years.

       

      I have tired making the dimension: If(max(Yearord)<=Year(Today())-3,name) but this is not working.