Re: Append columns with merged columns in PIVOT Table
Since they are different dimensions (or even calculated dimensions), you have two options;
1. Create separate charts. Takes little effort but doesn't look like your example (IMG1)
2. Use ValueList() function to create your chart using a calculated dimension. Takes a bit more effort and requires you to think about how you want to make it dynamic (what selections impact the dimension values and how etc).