Exclude filter in Aggr function

[sara12]

Hey all,

I have an aggregation function and I want to exclude the month-filter  (Mois) but it dosn't work.

(Sum(distinct{<Mois=,[travaux]={muniserie},[Nom prenom Responsable ]-={'Alex'}>} [CA Global HT]), Id_stock))

If anyone can help me solve this problem, I'd be very grateful.

[sara12]

If anyone can help me solve this problem, I'd be very grateful.

[marcus_sommer · Accepted solution]

Your expression-code doesn't look complete. I assume a leading sum(aggr or similar is missing. If so you may need to apply the condition to the outer aggregation, too - maybe like:

sum({ condition } aggr(sum({ condition } Field), Dim))

[sara12]

It works, thank you.