0 Replies Latest reply on Oct 8, 2018 12:03 AM by Danny Xu

    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 %
      NSWVersion11002003002002204201200.285714286
      NSWVersion21012023032042024061030.253694581
      VICVersion11112223332222224441110.25
      VICVersion21102203302202204401100.25
      QLDVersion11011110102090.45
      QLDVersion210515152035200.571428571

       

       

      Here is the report we are trying to build:

       

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

       

      Thank you!