1 Reply Latest reply on Dec 11, 2016 2:47 PM by Nachiket Dekhane

    Calculate % Change?

    Greg Mooney

      It's been about 18 months since I have used Tableau and the latest version I was using was 9.??? and now I am back to 8.3.

       

      I am trying to figure out how to get the % Sales vs LY column to calculate correctly. This data set is with aggregate measures turned on and it the top level of a custom built product hierarchy. My formula is [Sales vs LY]/[LY Sales]

       

      Any help is appreciated:

       

      SnipImage.JPG