3 Replies Latest reply: Jun 14, 2018 5:33 AM by Youssef Belloum RSS

    Quarter Issue

    Villyee Anderson

      I have below Data Set, I want to plot line chart with Dimension as YearQuarter and Type, Measure is QTY.

       

      But my requirement is to take only latest 12 Quarter i.e. 3 Years. (YearQuarter is in Text format)

       

        

      YearQuarterTypeQTY
      Q1-13AB451
      Q2-13PQ156
      Q3-13RX245
      Q4-13ZS352
      Q1-14VT154
      Q2-14UV254
      Q3-14NA325
      Q4-14YZ342
      Q1-15MN315
      Q2-15ZS421
      Q3-15VT432
      Q4-15UV421
      Q1-16NA412
      Q2-16YZ142
      Q3-16MN254
      Q4-16UV325
      Q1-17NA342
      Q2-17YZ315
      Q3-17MN421
      Q4-17ZS412
      Q1-18VT142
      Q2-18UV254

       

      Please suggest set analysis for this erquirement.

       

      Thanks,

      Villyee.