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?