Need help creating a visualization to show which reps are assigned to each customer

Anonymous — Wed, 30 May 2018 15:36:45 GMT

Hi,

I need help creating a visualization showing the count of service reps assigned to each customer as well as being able to show which reps.

I have a table containing one column “customer name” and then several other columns showing service reps related to that client. See below

Customer Name	Service Rep 1 (Tom)	Service rep 2 (Dick)	Service Rep 3 (Harry)	Service Rep 4 (Michael)	Service Rep 5 (Scott)	Service Rep 6 (Dwight)
McDonalds	x			x	x
Burger King	x	x			x
Wendy’s			x			X

Ideally would like to select a customer (ex. McDonalds) and be able to see that it has 3 reps and be able to see that they are Tom, Michael, and Scott.

I was thinking to just do a chart and show a yes now but in my actual data i have much more then was

Appreciate any advice on how to display this.

Re: Need help creating a visualization to show which reps are assigned to each customer

vishsaggi — Wed, 30 May 2018 16:37:39 GMT

You can use Pivot table. And can you share some sample data to look into?

Re: Need help creating a visualization to show which reps are assigned to each customer

vishsaggi — Wed, 30 May 2018 18:02:17 GMT

Did you try with Pivot? Did it work?

topic Re: Need help creating a visualization to show which reps are assigned to each customer in App Development

Need help creating a visualization to show which reps are assigned to each customer

Re: Need help creating a visualization to show which reps are assigned to each customer

Re: Need help creating a visualization to show which reps are assigned to each customer