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.
Hi acbg,
Have you solved your problem?
If you have solved, please accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.
If you still need help, please share some data sample so that I can copy and test.
Best Regards,
Cherry
v-piga-msft here is a sample data you could use
Fact table:
Sales Rep ID Sales Total
1 5000 2 2000 3 500 4 500 Dimension:
Sales Rep ID Sales Rep Name Sales Manager Name
1 Sales Rep 1 Sales Manager A 2 Sales Rep 2 Sales Manager A 3 Sales Rep 3 Sales Manager b 4 Sales Rep 4 Sales Manager B
