Total sales before an "end-period" about "actif programs"

[adequation_jna]

Hello all,

Our need is below  :

- #01 :  identify all couple "program / type" actif in a period. Actif significated, having unless one sale in the year.

- #02 : for each couple "program / type" we have to sum all sales about this couple "program / type"  before the end of the current period ( sales performed during the current year and during previous years)

static formule(OK) :

sum(aggr(
Sum(total <Program,Type> {<Date={"<=$(=makedate(2015,12,31))"}>} Sales)
,Program,Type,Year))

dynamic formule(KO) :

sum(aggr(
Sum(total <Program,Type> {<Date={"<=$(=makedate(""DAT_year"",12,31))"}>} Sales)
,Program,Type,Year))

We have no issue to do this calcul for a fixed year, but when we tru to do this for a year given in dimension we are facing an issue (we think is due to the total)

Thx for you times ,

[adequation_jna]

// Ko dynamique
sum(aggr(
Sum(total <Program,Type> {<Date={"<=$(=makedate(""Year"",12,31))"}>} Sales)
,Program,Type,Year))

sorry for copy/paste issue : Year is the field and not DAT_Year!!!