5 Replies Latest reply on Jul 11, 2019 11:27 PM by koushik.neelakantha

    PY Sales WRT Month & Quarter

    koushik.neelakantha

      Hi everyone,

       

      Please find the attached workbook.

       

      Requirement:

       

      If i select 2019 from year parameter my CY will be 2019 and PY will be 2018. If i select Month/quarter ,my Previous year(2018) should not get change. only my CY values(2019) should get change. Even though if i select Month & quarter, my 2018 values should show for entire year.

       

      Same with year parameter 2018.If i select 2018 from year parameter my CY will be 2018 and PY will be 2017. If i select Month/quarter ,my Previous year(2017) should not get change. only my CY values(2018) should get change. Even though if i select Month & quarter, my 2017 values should show for entire year.

       

      Regards,

      Koushik.

       

      Zhouyi Zhang

      Mahfooj Khan