Forum Discussion
Splitting customer turnover
Dear, I am having difficulty with following: I have customerdata which I would like to attribute to our account managers. Most of the customers have a direct relationship with only one AM, but ...
There must be more than one entry for at least one combination of customer and account manager
I just wanted to add following:
This is the whole idea.
I have some customer (of whom I only have 1 value in the fact table), but I want to split those across the account managers. Others only have 1 account managers contribution. Therefor I would want to have a matrix level performance in which I can see both the total value and split performance of the customers where it is necessary and other customers where there is only 1 account managers attributing to the customer.
Hope this is a bit clear?
Br,
Ken