Yan,

I started looking into it, but was in need of some clarifications.

To be the last operation, is that the same as having the highest [N° de Op]?

If so, you can use a Level of Detail calculation to fix the max for

all points for use in later comparison [MaxOpNumber]:

{ FIXED : MAX([N° de Op])}

Then to filter to get a curve for each bond rating,

which variable in your set corresponds to the bond rating?

In the attached example, I just used ISIN and said,

find the ISIN that has the highest OpNumber and

just filter to that.

[Isin]=[ISINMaxFix]

[ISINMaxFix]

{ FIXED :MAX([ISINMaxOp])}

[ISINMaxOp]

IF [N° de Op]=[MaxOpNumber]

THEN [Isin]

END

Yan,

Thank you for the information.

In need of a few more clarifications.

The max [N° de Op] seems to only be associated with [Calificacion] of "pyAAA".

It is not clear how to get a curve for each bond rating if the max Operacion is only associated with one rating.

The attached finds that [Calificacion] for the max [N° de Op], and then filters the graph to just points of pyAAA.

It may be helpful to mock up a drawing of what your desired graph should look like.

Here are some links about Level of Detail calculations:

From: FIXED Level of Detail Expressions

"FIXED level of detail expressions compute a value using the specified dimensions, without reference to the dimensions in the view."

Overview: Level of Detail Expressions

Level of Detail (LOD) Expressions | Drawing with Numbers

Yan,

Sorry for all the back and forth.

Please see Sheet 5 of the attached.

To get the max for each ISIN, then you'll need to use:

{ FIXED [Isin]:MAX([N° de Op])}

Then as a filter

[N° de Op]=[ISINMaxFix]

which should only return the max [N° de Op] for each ISIN.