Can you please share a sample workbook.
This should be possible but solution will depend on your data structure.
I can set up the data in almost any way needed, as I have admin access to the data warehouse.
I can't even get started on this to get a workbook, also I haven't got the samples installed
Could you please share a sample set of data in excel Feel free to change values of fields if this is sensitive data.
Just to try get an understanding of what you have as a current structure and what changes you would need for an easy solution on this if it is not possible to achieve entirely in tableau