Sum(Distinct Value) Trying to get the sum of?
I've got a dataset that gives me an employee count and an employee count target by location.
When I view this by location it gives me the correct values with the target value coming from the following Beastmode:
The employee count comes from this Beastmode:
When I want to see this rolled up into a market however the employee count seems to roll up fine, but the Target value is rolling up to a value of 35 which appears to be the number of entries and not the sum value of the Beastmode, it should be more along the lines of 129.
I've tried a couple of methods using Case Statements etc but to no avail.