Creating MEASURE: need to divide Team total by Manager Quota

[pete234]

I managed to connect my sales table pivot to a quota query feeding from Access.
Manager Quota Qtr repeat in the data at team level in my normal week view.
I know I could create a measure to see what % of the Manager's quota a rep contributed to
but how do I create a measure of the team total sales to manager quota?

The layout is by weekly sales can anyone suggest a measure for this?

The fields are:
1)Manager 1a)Team 2)Rep Name 3)Mgr Qta Qtr (repeats) 4)Rep Qta Wk 5)Sales Total Week rep level

thanks

 

[Laurent C]

Say you have managers M1 & M2 and teams T1 & T2, how would your calculation be defined for all possible combinations (below)?

Manager Team
M1 T1
M1 T2
M2 T1
M2 T2
M1 All Teams
M2 All Teams
All Managers All Teams

 

[pete234]

For some reason this double-posted sorry about that.
But I still could use a tip on dividing the mgr line by SUM of team.
Also, Team and manager are basically the same level so it's probably easier.

I just need to divide the SUM Of T1 by M1 Qta Qtr.
And then, SUM of T2 by M2 Qta Qtr.

This will be helpful if I can fix my running total on sales.