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 ...
It apears I can get a matrix going now, with everything showing per account and divided per account manager, however the wrong values are showing AND it's always the same value.
So as you can see in the example below the total sales value doesn't match and it repeats for every customer
edit: I resolved the values issues, where it didn't show the same value in the matrix table. I referenced another mapping, which seems to have done the trick.
Only stuck with having the same value for each and every value in the matrix table now.
that looks like both the customer and the account manager fields are coming from tables which do not filter the invoices table. either that or the measure definition is using ALL or REMOVEFILTERS where it shouldn't
