Find my approach based on "pivoting" in Tableau as reference below and stored in attached workbook version 10.1 located in the original thread
1. Edit datasource > select column Bonus & Comission > V > text menu > Pivot
2. Rename Pivot Field Names > Right Click > Text menu > Rename : Pay Type
4. Drag all required objects to the indicated locations.
pivoting_nalmai_10.3.twbx 17.7 KB
Thanks, We were hoping to be able to do it in the Visualization- not in the data source but that's ok. It is what I figured it would be.