3 Replies Latest reply on Dec 6, 2018 7:22 AM by Ciara Brennan

    Global LOOKUP(MIN(Date),0) Filter

    Karthik Seshachari

      Hi Everyone,

       

      I'm using the LOOKUP(MIN(Date),0) filter so that it doesn't affect my % Difference calculation for the underlying data.

      So, I'd like to find a way to have a global date lookup filter for all worksheets.

      I tried looking into previous discussions like this one - Creating a Global LOOKUP(MIN(...),0) Filter with a Parameter for "Jedi" Filter and Table Calc Trick , but I'd it to work for a relative date range (Last 3 months).

      Does anyone have any tips or suggestions on achieving this?