3 Replies Latest reply on Jul 23, 2018 7:04 AM by Eric Brennan

    Calculated field to get year for Quarter selected from filter

    Shruthi B S

      Hi Everyone,

       

      Could you please suggest me to create a calculated field to get the  year for the quarter selected from the quick filter. I want to get Sales for that particular year.

       

      Eg., I have quarter in the quick filter. If i select '2018Q4" from it , i want a calculated field that fetches me year and sales of that year.

       

      Attached sample workbook with data.

       

      Regards,

      Shruthi