Expression Total

[sona_sa]

Hi, 

I have 4 dimension and expression in pivot table. Now I want the total for zone wise and Using  Distinct in expression. Now if I am using Distinct Value in Expression then it is giving wrong value in expression.

My Output should be - 140 but it is giving 118. But I want to use Distinct in my expression.

Expression = Sum of Target.

Can anyone help me on this.

Regards,

AS

[edwin]

this just means that whatever field you are counting distinct of is shared across Location at the least which means 118 is correct.  if the field you are counting in one location is not the same for the same value in another location then maybe you can do a distinct of location + FIELD and not just distinct of FIELD

if this does not help, you may need to give more info