Sum() of id dimension duplicated in bar chart

[_akhan7qv]

Hello,

I have a table which contains a set of references, in a group, with a number to sum() on a given month, it goes like this:

I'd like to display in my bar chart the number of SUM() of "canaux" for a "refcom" for each month (janv and feb) regardless of the "sub" field. So I should have for each month 10 and not 20, how can I do this ?

Currently my expression is just sum(canaux) and my dimension "mois"

Regards,

[MayilVahanan]

Hi @_akhan7qv 

Can you try with distinct 

 sum(distinct canaux)

[_akhan7qv]

Hi, in this small example I provided it will work but on a bigger project it won't because I can have the same value for "canaux" several times for different refcoms.

I'd like to compute the sum() of canaux for each month based on the number of refcoms and deduplicating the field "sub"