Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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,
Hi @_akhan7qv
Can you try with distinct
sum(distinct canaux)
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"