1 Reply Latest reply on Oct 23, 2018 11:42 AM by Yuriy Fal

    Calculate the Differences of Multiple Pairs of columns

    Danny Xu

      Hi Guys, I am trying to replicate an old Excel document report, but running into this difficulty in calculating the differences in Tableau. I have read a few discussions, but they all appear to be showing the comparison(running total) of two columns only, not multiple comparisions.


      Hence I am reaching out to the wider Tableau Community for help. Thank you for your time in advance.


      Here is what the source data looks like



      STATEVERSIONCost1Cost2Total CostRevenue1Revenue2Total RevenueProfitProfit %



      Here is the report we are trying to build:


      The packaged workflow has been attached. Looking forward to your suggestions.


      Thank you!