3 Replies Latest reply on May 10, 2018 2:59 AM by Red TypeR ha

    LOD Prior Sum ignore Year Selection (MOM)

    Red TypeR ha

      Hi Guys

       

      I have a situation where i want to compare MOM ( in which the prior month ignore the filter year)

       

      User selects   Year and Month ,  if i select Year 2018 and Month 11,

       

      then Sales  is  sum(2018,Nov, Sales)

      Prior Sales is  sum(2017,Nov,Sales)

       

      somehow it doesn't work on my workbook (show 0) and hope you guys can help. Thx

       

       

      Prior Formula

       

       

      Want