Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a problem, I have a table has two column ,
1-DATE:date_s
1-Indicateur :
SUM({<date_s,month={"<=$(=month)"},year={"=$(=MAX(year))"},PRODUIT = {"CREDITS"} , NATURE={"CREDIT A LA CONSOMMATION"}>}PRODUCTTION_VOLUME_TND),
indicateur is the it is the cumulative measure from January to the month displayed in the date column
i used this expression but the result is false, after the analyzes I noticed that the result is date = date and not cumulative
If you add an extra dimension then you should add an aggregation over the rangesum.
AGGR(RANGESUM(ABOVE(SUM({$<month={"<=$(=month)"},year={"=$(=MAX(year))"},PRODUIT = {"CREDITS"} , NATURE={"CREDIT A LA CONSOMMATION"}>}PRODUCTTION_VOLUME_TND),0,ROWNO(TOTAL))),AGENCE)
when you select MARS and APRIL, you want this:
01/01/2017 100
01/02/2017, 400
16/03/2017, 800
27/04/2017, 950
??
yes
the expression i gave you below give 950 if you select mars and april.
Good luck
see attached, make the same selections (mars and april)