1 of 1 people found this helpful
Is this what you want?
To achieve the above, I modified your data source to create a copy of the Products Sold column, and then pivoted the data in Tableau as shown below:
You can see the rest of the steps in the updated workbook attached.
Hope this helps.
Thank You Hari.
Really appreciate your help.
If I have 2 datasets from different sources and they are blended together will this approach work ?
Because I cannot do pivot when there are more than one data sources.
Is there an alternate to this approach ?
You will need to try to see if it will work with blended data sources. If you cannot do pivot, you should look at doing union of the data with itself and create calculated fields to simulate the pivot functionality.