9 Replies Latest reply on Jul 4, 2012 11:43 PM by Anurag Gulati

    Calculating Year on Year Growth

    Anurag Gulati

      Hi Guys,

       

      I am stuck with this issue in Tableau. I want to calculate year on year growth and then consolidate them by Industry. I am using the formula

       

      (Current Year Sales -Previous Year Sales)/Previous Year Sales

       

      I created a custom calculation and when I added it to Measure Values the percentage growth shows 1000% even though there was a decline in the figures. My question is how to create a proper Calculation and then add it to measures?

       

      Thanks

      Anurag