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

    Dynamic updating

    Ross Oliver

      Hello,

       

      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?

       

      Thanks

        • 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!