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

    Table Calc Difference based on Dimension




      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!