1 2 Previous Next 15 Replies Latest reply on Jan 26, 2017 9:30 PM by Alan Asher

    Fixed LOD calculation - how do I exclude dates in my filter?

    Annie Lum

      Hi All,

       

      I'm starting to work with LOD calculations.  I wanted to modify the common example in the attached workbook for my own use.  However, because I need a Fixed LOD, I can't work out how to filter using a date.  Please see Sheet 8, I have included in a Date Filter, but this is ignored because it is a Fixed LOD and the calculation occurs before the filter is applied.  So, it still counts all the orders for the entire data extract (like in Sheet 6), but really I only want it for a particular date range.  What can I do so that it only shows the chart for a particular date filter?

       

      Thanks.

       

      Annie

        1 2 Previous Next