5 Replies Latest reply on Mar 17, 2016 9:15 AM by andy.yu

    Table Calc Difference based on Dimension

    andy.yu

      Hello,

       

      We're currently running Tableau Desktop 9.0.5

       

      I was trying to play around with table calculations, but couldn't get it to work exactly what I needed it to do

       

      • I was hoping to accomplish the following
        • Find the difference of Actual and Budget 2 (5000.00 - 3000.00 = 2000.00)
        • Find the difference of Actual and Budget 1 (5000.00 - 10000.00 = -5000.00)

       

      • When I try to do table calculations, I know I can do relative to: Previous, Next, Last, First
        • But it doesn't quite calculate correctly because I want to have the difference always based on "Actual"

       

      Is this possible to do? Should I try to do a LOD expression if that helps?

       

      Thanks for any advice or help!