1 Reply Latest reply on Nov 20, 2013 9:01 AM by Michael Evans

    Dynamic updating

    Ross Oliver



      I am creating a traffic light system for meetings.


      I want to see organisations, who we have not met with in the last 12 months.


      What would be the best way to do this?



        • 1. Re: Dynamic updating
          Michael Evans

          Hi Ross!


          I approached it like this.  I used superstore sales as an example.  I Created a calculated field: "Order Date (Date Only)"

          DATE([Order Date])


          Then another caculated field: "More than 11 months since last order"


          DATEDIFF('month',MAX([Order Date (Date Only)]),TODAY()) > 11


          I used those both in the attached workbook and then hid the values when "More than 11 months since last order" = false.


          Hope that helps!