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.



      Murthy Pidugu