Thanks for your workbook.
Please find my solution attached.
Below is the screenshot of calculation fields I created for your reference.
Hope this helps
Thanks, it worked!
No worries, Ward. I am glad to help
Can you mark my answer as correct to close the thread?
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...