You shouldn't really be thinking about Sheets, you should be thinking about Measures. Profit and Expenses are measures, both dimensioned by Depeartments (and probably some others as well).
In Tableau you simply create a Calculated Field that would be [Profit] - [Expenses]
then when you use that in any capacity in Tableau, it subtracts the Expenses value from the Profit value - this could be a third sheet, or you could put all three on the same sheet.
For your real-life example it could be much the same - check that the dimensions of both measures are the same (or similar, depends on what you want to achieve) and then create a calculated field. Test it to make sure it's working how you expect, and you're done
It's quite difficult understand what do you mean by "Tableau Sheet".
Tableau is different from Excel and does not have a concept of Sheets.
If you can attach sample packagd workbook, that helps us to understand your issue.
Unfortunately I cant upload the workbook because it is sensitive information. Let me ask this question differently to hopefully add another thought that may help. I have measure that is a count of a uniqueID and the dimensions are hiring department and current department and this information is in every persons record (row). Think of it as Susie started work in Department North and now works in Department South. Jane started in Department West but now works for Department North. Susie and Jane's records both have dimensions hiring department and current department. I can make a table that shows how many people started in each department when they were hired and I can make a table of how many people are currently in each department with simple counts in a table. Is there a way to do a subtotal in a regular calculated field. Something like North.Hired - North.Current?
The data set is large-ish (75K rows) and the departments are numerous so it's not practical come up with all the combinations of people switching departments using IF statements.
Thanks for keeping the conversation going. I hope I didn't confuse things with an alternate example.
Hopefully the hiring department and current department are 2 different dimensions, then you can do [Hiring Department} <> [Current Department]
Without publishing your REAL data, maybe some sample dummy data would help. Make it the same dimensions that your real data has, but the values should be fictitious
Kimber McDevitt wrote:
Unfortunately I cant upload the workbook because it is sensitive information. ...
You can anonymize your workbook:
The workbook will be helpful here. You'll need to do different things if the numbers on your respective sheets are from table calcs, sums of measures, or values from aggregate calcs.
But the bottom line is that you need to derive the values within the sheet where you want the math to be done.