Forum Discussion
Graph two columns on same axis
Ok so let me clarify:
A Sales Rep has sales and manager.
A Sales Rep's sales are his sales only.
A Sales Manager is his sales plus the sales of any Sales Rep below him. Is that correct?
If thats the case, you'd need to create a measure that does 2 sums and adds them together. The first sum would simply be "Sales with my name on it" and the second would be "Sales where I'm the manager".
Now Sales Reps will always be 0 for that second one, so it should work fine. Sales Managers who don't actually sell will be 0 for the first one. Overall you should get the right number and you can then place this onto the same Axis. The only thing you'll need is a list of Employees to act as your Axis.
Thanks for the reply Anonymous
But when you bring the column into value box it changes to count instead of the actual category.
Put the Sales Rep name into the Legend Box.
Thanks! That still does not show the sales manager and sales rep side my side.
If we have the sale maanger on axis and sales rep in the legend. It does not show sales manager total.
The only way I can see a decent outcome is to put both sales manager and sales rep in the axis column and have the user drill down.
I must not be completely understanding what you are achieving I think. Can you do a quick MS Paint mock up of what you are hoping to see?
Please see below, trying to compare both sales manager and sales rep in the same chart side by side.
Ok so let me clarify:
A Sales Rep has sales and manager.
A Sales Rep's sales are his sales only.
A Sales Manager is his sales plus the sales of any Sales Rep below him. Is that correct?
If thats the case, you'd need to create a measure that does 2 sums and adds them together. The first sum would simply be "Sales with my name on it" and the second would be "Sales where I'm the manager".
Now Sales Reps will always be 0 for that second one, so it should work fine. Sales Managers who don't actually sell will be 0 for the first one. Overall you should get the right number and you can then place this onto the same Axis. The only thing you'll need is a list of Employees to act as your Axis.
Hi acbg,
Based on your information, it seems that the sales total of Sales Manager A is 7500, it seems that is the sum of 5000+2000+500.
I'm a little confused about this result. I think the sales total of Sales Manager A should be Sales Rep 2+Sales Rep 1=7000.
Could you describe your logic in more details?
Best Regards,
Cherry
sorry graph was created early on and data was just something sample I put together.
