There is a total using pick if you rick click the pill, but from your statement the OR is Column A divided by Column B - does not follow from the values that I see.
1 of 1 people found this helpful
I'm guessing you need to apply aggregations -- try SUM(Expenses) / SUM(Revenue) -- without the aggregation, you will see incorrect results in the view:
Here's a video explaining the concept: Aggregation, Granularity, and Ratio Calculations | Tableau Software
If this does not help, please consider posting a sample Packaged Workbook (.twbx) along with what version of Desktop you are using, so others can see the data and apply help. Its difficult to help without having a workbook, and nearly any scenario can be mocked up since we can simply copy and paste data out of, and into, Tableau Desktop.
Best of luck!
Thank you - This is what I did. I realized this after I stepped away. I got lost in the forest because of all the tree's. Thank you!!