Compare Salesperson to Overall Sales

[Oros]

Hello.

I have the SALES TABLE with salespersons column.  How do you compare the salesperson's sales with overall sales showing in a grid like below, but with a slicer for to filter each salesperson?  Thanks.

SALESPERSON	SPECIFIC SALES	OVERALL COMPANY SALES
Adam	2,000	25,000
Cathy	1,500	25,000
Kyle	3,500	25,000

[v-xiaosun-msft · Accepted solution]

Hi @Oros ,

You can create a column by using DIVIDE function to show the specific sales as a percentage of all company sales.

Column = DIVIDE('Table'[SPECIFIC SALES],'Table'[OVERALL COMPANY SALES])

Or you can put "specific sales" and "all company sales" into a clustered column chart and then put "salesperson" into a slicer, then you will visualize how sales of each salesperson compares to all company sales.

If this is not what you need, please describe how you want to compare two columns more clearly and provide the expected output.

I attach my sample below for your reference.

Best Regards,
Community Support Team _ xiaosun

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-xiaosun-msft · Accepted solution]

Hi @Oros ,

You can create a column by using DIVIDE function to show the specific sales as a percentage of all company sales.

Column = DIVIDE('Table'[SPECIFIC SALES],'Table'[OVERALL COMPANY SALES])

Or you can put "specific sales" and "all company sales" into a clustered column chart and then put "salesperson" into a slicer, then you will visualize how sales of each salesperson compares to all company sales.

If this is not what you need, please describe how you want to compare two columns more clearly and provide the expected output.

I attach my sample below for your reference.

Best Regards,
Community Support Team _ xiaosun

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Oros · Accepted solution]

Thanks @v-xiaosun-msft !

It works!