Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
if somebody can help me
I want to display the first value and the last in a graph,
as shown in the following histogram
Thank you for your help
Djallel SADKI
I think you can check in your expression whether the dimension is Min or Max and otherwise results in Null?
If(Dim=Min(Dim) or Dim=Max(Dim), expression, null())
it only shows the value of the selected month
the expression is:
=Sum({$ <Année= {$(=Only(Année))},Mois={"<=$(vThisMonth)"}>}[1.4])
/Sum({$ <Année= {$(=Only(Année))},Mois={"<=$(vThisMonth)"}>}[1.3])
The dimension is the Month
Thank you for your help