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
|STATE||VERSION||Cost1||Cost2||Total Cost||Revenue1||Revenue2||Total Revenue||Profit||Profit %|
Here is the report we are trying to build:
The packaged workflow has been attached. Looking forward to your suggestions.