3 Replies Latest reply on Feb 24, 2016 9:47 PM by Shinichiro Murakami

    Looking for help with MOM(month over month) KPI calculation

    Dorothy Yu

      Hi

       

      I'm looking for help with MOM KPI calculation.

      Attaching the workbook below for reference.

       

       

      Basically I want to have a month filter to control MOM KPI. If user selects February, KPI should only show Feb MOM(Feb MOM=Feb profit - Jan profit) . However now I need to select both Jan and Feb in order to show that value... Ideally I'd like to select only Feb to make it happen.

       

      Also by default when I'm not selecting any month(all months are selected), I want it to show MOM as of Dec 2013... Is that possible?

       

       

      Thanks in advance!!!

       

      Dorothy