Display an evolution by time and dimension

[marakud971]

Good morning all,

I am contacting you to request your assistance.

Indeed, I have a request from a client that I cannot manage to implement.

He would like to compare elements of a dimension over time (Year, Semester, Quarter, Month, Week, Days) by a dimension in Year-to-Year mode.

To understand i'll give you an example.

I have a dimension with several values.
In the same graph and for each value of the dimension,
I would like to see the evolution of the measure by Semester (or Quarter or Month or Week or Days) and that for the year N and N-1.

If my dimension has 3 values, in total I should have with 6 values.
3 for year N and 3 for year N + 1.
And all this in a the same line graph.

Thank you a lot.

Have a nice day

[Taoufiq_Zarra · Accepted solution]

a version is attached in this post

for category A and year  2020 the syntax will be :

sum({<OPERATEUR={'A'},ANNEE={"$(=Max(ANNEE))"}>} NB)