5 Replies Latest reply on May 3, 2012 9:33 AM by Michael Nealey

    Filter dates out but have calculations still reflect filtered dates

    Michael Nealey

      Attached dashboard shows the same data in 2 sheets.

      In top sheet, all my data is visible.

      In second sheet, I have filtered data so I only see 2010 - 2012.

      The "moving average" calculation I have on both sheets is a different value. How can I have the value on the 2nd sheet be the same as the value on my 1st sheet, even though I have a filter on the dates?

       

      Thanks!