-
-
-
-
Re: prior year
Yes, you can see with this picture :
Before annee was a String but I modifiy in integer in the database and I refresh data.
-
-
Re: prior year
I use your expression without and with selection on annee field. Because, I want when I will select value 1981, I want value for 1971 and 1981 side by side.
-
Re: prior year
I try to create a variable like this anneeV : $(=annee+10). Then I use this variable in a set analysis like this : sum(${<nom_Mesure={exp}, annee={$(=anneeV)}, nom_Du_Pays-={'Monde'}} valeur).
But value display are this of current year select...
-
Re: prior year
How about this, doesn't work?
Sum(${<nom_Mesure={exp}, annee={$(=Max(annee) - 10)}, nom_Du_Pays-={'Monde'}} valeur)
-
-
-
-
-
-
-
-
-
