This content has been marked as final. Show 4 replies
I have the data model as in the attached screen. It created a circular reference that i need to resolve.
How can i resolve it?
Note that SMID means SalesManID, and as output i need to build a pivot table which shows the Target and sum of sales by brand and by sales man.
Also note that each item belongs to a brand and the target is by brand.