2 Replies Latest reply on Nov 17, 2016 8:32 PM by John Markley

    how to do a share growth calculation

    rar man

      Hi i have data set up in the following way:

      division , market,  year, quarter, revenue ,industry revenue

       

       

      in my work sheet i am displaying: division |   market in rows and year in rows too.. i tried putting year in columns and i am having the same problem. my mesure name is in column

       

      i want to show a share growth calculation..how would i great a calculated field so it calculates and shows: (2016 revenue/ 2016 revenue)/(2015 revenue/ 2015 revenue)-1?