1 Reply Latest reply: May 15, 2017 9:26 AM by Manish Kachhia RSS

    how to show YOY in percentage

    naveen kumar

      Hello , i have to show YOY change in percentage

       

       

      sample data  i got is

       

      Group   Year           value

      AD          2014          17713

      AD          2015         15012

      AD          2016          13875

      MF          2014          82742

      AD          2015         81375

      AD          2016          95777

       

      currently what  i am showing in a line chart

      Dimension:1)Year

                        2)Group

       

      Expression:sum(value)

       

      line.png

       

      what i want to show is  YOY of each year

      i mean

      on top line chart

      81375-82742 in percentage

      95777-81375 in percentage

       

      on bottom

      15012-17713 in percentage

      13875-15012 in percentage

       

       

       

       

      So how to show those diff plz

       

      thanks

      naveen