3 Replies Latest reply: May 2, 2017 2:20 PM by Sunny Talwar RSS

    How to show top 2 Ytd wise.. with 2 dimension..

    Kavita Vishwakarma

      Hi, I want to show top 4 in line chart.. where my dimension is Month & Competitor.. YTD, QTD wise on selection.

       

      For e.g :

       

       

      MonthNameValue
      AprA100
      MayA200
      JunA102
      JulA120
      AugA140
      SepA130
      OctA80
      AprB150
      MayB300
      JunB105
      JulB120
      AugB150
      SepB230
      OctB180
      AprC200
      MayC400
      JunC360
      JulC120
      AugC520
      SepC230
      OctC165

       

      Line Chart has two dimension Month & Name.

      Expresssion is : Sum (Value ) / Sum (total Value)

      For A will be : 100/450 as the % in the chart..and same for others.

       

       

      Now I want YTD i.e if I select Jun then it should give for A

      Sum of value for A  402 and total value is 1917...

       

      On the basis of YTD, QTD i want top 2...