Forum Discussion
Filter Columns
Hi I am trying to set weighted targets for some sales people based on a straight divison of the overall volume increase by the number of sales people. This is fine except my products are in diff...
I'm not clear on what you try to achieve with 'FRY Data'[Pack Size.1.Product] - is it supposed to be filter, or something else?
from your description I would assume that the measure should be something like:
[volume increase]/[number of sales people]
but I don't see any relation to that in the code you posted
Many thanks for your reply, what I am trying to do (not very well) is determine an equal volume target per sales person.
That in itself is relatively straight forward however I have 4 product categories that require different targets.
So in essence what I want to do it take the target value for each product type, divide this by the number of sales people and add that number to their target (seem simple when I write it down!!!)