Perhaps you could try to do a Split on the Sale Agents column in the Data Source, which will give you each of the agents in separate columns.

Then to be able to do aggregations of the different sales agents, you would want to Pivot the columns into rows - look into using Tableau Pivot().

Hope this helps

Hi Mrinal,

In the data connection pane, you can 'Split' this column at the commas if you aren't able to connect to this file as a CSV.