I have a question that i cant seem to solve.
I have the following table:
|Region Coverage||Sales Employee||Targets|
Since, the region is the same and the targets are the same, can we have the total to be 1,350,000 since all targets in the regions are the same?
Thank you in advance.
Here is the script I've used:
LOAD * inline [
Region Coverage, Users, Target
Hello Sunny, Thiago,
Using your script and expressions, this is what i get.
Except East, other regions have their own targets that should appear. Only east is the exception.
If(Dimensionality()=0,Sum(Targets),Sum(total <[Region Coverage]> distinct Targets))
I am guessing Current Result uses Sum(Target)... if it does, then I think this should work
If([Region Coverage] = 'East', Aggr(NODISTINCT Sum(DISTINCT Target), [Region Coverage])), Sum(Target) )