Get last value per year and month in accumulated.

[cristianj23a]

Hi, In this line graph I get the accumulated values that the user requested, but want the value of the last month and year selected.

In this case the maximum value is 171281.50.

In this simple table there is no filter, therefore the maximum value April / 2017, if I select 2016 the maximum value is December / 2016.

Please, someone can help me how to solve this problem?.

I attach the QVW and Excel.

[sunny_talwar · Accepted solution]

Try this

=FirstSortedValue(Aggr(Avg(Aggr(RangeSum(Above(Sum({$<Año,Nom_Mes>} [Ctd.en UM entrada]), 0, RowNo())), Material, (Fe.contabilización, (NUMERIC)))), Nom_Mes, Año), -Aggr(Nom_Mes + (Año*100), Nom_Mes, Año))

[cristianj23a]

Thank you very much, is correct