3 Replies Latest reply on Dec 3, 2013 10:15 AM by Thomas Tegtmeier

    Date filter/previous period change over time - automatic

    Kristy McGee

      I know the subject maybe a little convoluted.  I need a measure similar to the table calculation for % increase or decrease but I need this by itself. 

       

      We have a date filter (MY[DateCompleted]) that will show a completion figure.  I would like to set up a calculation that gives us the filtered month&year with the change +/-.  I need this to be a 'free-standing' field. 

       

      It would look like this

       

      January 2012

      1,000 Completions

      50% over prior month

       

      Can someone please point me in the right direction? 

      Thanks,
      Kristy