2 Replies Latest reply on Oct 10, 2016 7:32 AM by David Li

    Running Average and Filter

    Edward Yeldham

      Hello,

       

      I have monthly production data (volume and number of records).  I have used the quick table calculation to calculate the running average batch size as below.  For the 1st 3 months of my fiscal year the data displays as shown below and is correct.  I only want to show the current months YTD avg though and the comparative for last year.  If I restrict the view via a filter then the table calc errors - presumably because the filter shelf has removed some of the data needed to generate the calculation.  How do I go about only showing the Sept data whilst still having Jul and Aug in the calc?

       

      Ed