get value less than or equal to selected ID_ANNO_SEMANA

[cristianj23a]

Hello, I need help.

I have a case where I have a filter, ID_YEAR_WEEK, configured to always retain a selected value.

But in the table chart, I want the following condition to be displayed in column "a."

That the values ​​of the "TARA_POND" are displayed but only with the value less than or equal to the selected ID_ANNO_SEMANA, for example in this case I am filtering the ID_ANNO_SEMANA = 202545, then for the ID_PERIODOMENSUAL = 202512 it should show the TASA_POND of the ID_ANNO_SEMANA = 20245, not 202549 since it should be less than or equal to the ID_ANNO_SEMANA, the same in ID_PERIODOMENSUAL = 202511 it should show the "TARA_POND" of ID_ANNO_SEMANA = 20215, the same in ID_PERIODOMENSUAL = 202509 it should show the TASA_POND of the ID_ANNO_SEMANA = 202538 which its value is 0.58, since 202538 is less than or equal to 202545, so it should obey that condition when filtering another ID_YEAR_WEEK.

The results should be those with the red border in the image.

I would appreciate your help.

Regards.

[rubenmarin]

Hi, you can try with:

FirstSortedValue(TOTAL <ID_PERIODOMENSUAL> {<ID_ANNO_SEMANA={"<=$(=Max(ID_ANNO_SEMANA))"}>} TASA_POND,-ID_ANNO_SEMANA)

If you want to show the TASA_POND as 0 for higher ID_ANNO_SEMANA values, you can add a condition like:

If(Only({1}ID_ANNO_SEMANA)>Max(TOTAL ID_ANNO_SEMANA)
  ,0
  ,FirstSortedValue(TOTAL <ID_PERIODOMENSUAL> {<ID_ANNO_SEMANA={"<=$(=Max(ID_ANNO_SEMANA))"}>} TASA_POND,-ID_ANNO_SEMANA)
)

[cristianj23a]

Hi, it's the same as what I tried.
It doesn't meet the condition.

Regarts.

[rubenmarin]

Hi, you should have something different, this is what I see using the expressions in your attached app: