3 Replies Latest reply on Jul 17, 2018 10:11 AM by Scott Schmeling

    Filter on a Window / LOD Calc

    Scott Schmeling

      Good Morning,

       

      I am trying to create a table that can show Previous, Current, Difference as well as a trend line for previous 3 months.  I am able to get it working for the aggregate of all locations however I am trying to apply a - I want the numbers to change to show only that location.

       

      I have tried creating LOD equations as you can see in the picture below.  This is a snapshot of one that works for the aggregate of all locations but not the individual locations.  I have also attached a stripped down workbook without all the LODs, just tried playing with something a little simpler on this one- but can't get it to work for sheet 2.  The result should be equal to what is showing on sheet one for all locations.

       

      Thanks for you help.