I'm not sure I understood your request correctly, but if you simply want combine colors.
Pick Pay Code and Pay Code (Service) at the same time with control, then put them into color shelf.
You can swap the order of two field with just drag and drop.
In this case though, the number of color is too many and I'm not sure this is what you want or nor.
Test_Tableau Community_SM_10.1.twbx 364.8 KB
I think the inner join key ID is not enough to identify the pay code for service hours mapping to pay code.
below screenshot confused me a bit, e.g. Pay code as holiday, it maps to all the Pay code for service hours which I don't think it makes sense.
If you could adding mapping each of the pay code for service hours to corresponding pay code, and adding the key along id, then drag both pay code and pay code service hours into color, you should get what you expected.
Thank you for your reply.
What you are showing is exactly the problem I have. The dimensions: Pay Code from Employee Hours and Pay Code from Service Hours have to be combined without creating hierarchy and /or category/sub-category...
The goal is to end up with a graph as presented below (all categories on one graph with sum of hours for each). - To accomplish that, I had to modify the data in Excel:(
Still not sure I understand the goal correctly anyways..
Yes, what you need is modify excel data.
As long as header is aligned, you can use "Union".
Save excel file in same folder and use wild card union.