the "using filters" part I'm not exactly sure how to address, but you can create a calculation that divides one field by another quite easily, for example:
If you're able to share a packaged workbook (.twbx) file that shows where you've gotten so far, I could take a look and maybe help more?
Will this work across sheets?
I ask as usiis and usiid(comp) are on two different sheets.
Hi Richard, I don't know quite what you mean by "different sheets". If you are referring to:
- Different worksheets in Tableau - doesn't matter as the calculation is against the fields in the data source
- Different sheets in an Excel file - this should be OK if they are joined (showing up as one data source in Tableau), if they are blended (One data source with a blue check and one with an orange one) it is still possible to do, but you might not get the right results as blending is more finicky.
Does that help?