Sum when 2 column are equal

[#1]

When i select 'AA' in Fam1. I am trying to sum the column 'CA' for one customer when value of 'Fam1' = 'Fam2' like the Result Table.

Try with aggr but don't seem to work. Is it possible ?

Thanks

[#2]

Hi Marlot,

Here you are a possible solution.

Regards.

[#3]

Thanks a lot for your solution.

Is it possible to add the total CA for the Customer 003. (New Exemple) With Selected Fam1=AA

[llauses243]

Hi,

This is my offer ...

Good luck, Luis

[#5]

llauses wrote:
Hi,
This is my offer ...
Good luck, Luis<div></div>

Thanks ... but in my real case i only want to select fam1. I don't know if it is possible

[#6]

Hi marlot,

That isn't possible because you want fam1 field as dimension and you are selecting 'AA' in that field, so you would never get the null value for the Customer 003.

Regards.

[#7]

Well, Finally this a solution. It seems to work. I create a new field and compare it with set analysis.

Thanks for all your suggestions