3 Replies Latest reply on Jan 7, 2018 9:53 AM by Norbert Maijoor

    Calculated field for showing Latest and Previous Quarter Sales:(FY: Nov to Oct)

    Murthy Pidugu

      Hi Guys,

       

      I am looking for a help to calculate Latest & Previous Quarters sales for Segments.

      Like below, I also need to show 2 Quarters Sales details in the same worksheet by creating 2 Calculated fields.

       

      Here the problem with Fiscal Year. My FY starts from Nov to Oct. Based on that Quarters need to be shown. (Q1: Nov, Dec & Jan; Q2: Feb, Mar & Apr like this).

       

      I wrote the calculation like below, but am unable to restrict the quarters as I defined the FY. I have changed the FY for Orderdate and Superstore.

       

      Kindly help me for the right calculation for getting the quarter details.

       

      Regards,

      Murthy Pidugu