Last value of a dimension

[TomBond77]

Hi experts

We need the last value of a dimension "Category", this one is on the last snapshot "YM", Year Month.

Any ideas how to realize it?

[theoat]

You can do this with a variable.
Here's an example made on a personal case (I named the variable vLastFruit):

For your case, here is the formula to use in varibale vLastCategory :
{<YM={"$(=Max(YM))"}>}Category

When using your variable, keep in mind the $ --> $(vLastCategory).

Kind Regards,
Théo ATRAGIE.

[TomBond77]

Thanks,

Is this variable correct?

[theoat]

In my opinions, yes !

[TomBond77]

is this a text box?

[TomBond77]

something is yet not correct, can you help?

[TomBond77]

I corrected the variable: 

But I am still getting the wrong Event Reason in the table for 2023-Feb: For all month I would expect the last value from 2024-Jan. Any ideas?

[theoat]

In this case, add the operator 1 at your set analysis in the variable.
Like this :
{1<YM={"$(=Max(YM))"}>}Category

[TomBond77]

Thanks, I have changed the variable vLastEventReason:

But still get the same result:

[theoat]

Can you share the .qvf?