Are you still working on this?
I came across this old post. If it's still a problem, let's resurrect it.
I'm having a hard time wrapping my head around your description, though. So if you still need help, mock up an example workbook using your attached data. Describe what you are seeing, and what you hope to see. A hands-on look will help me grasp what you need to do.
Yes, I’ll try to mock something up and send to you.
I finally submitted to Tableau help desk and after several iterations was able to resolve.