PIVOT GET the max date for each month (set analysis or aggr?)

[#1]

cannot figure out how to get the max date for each month selected and the tot sum of stock:

FOR each id_code (in the example there is only one id_code) I would like to get the stock at the maximum date available for the selected months

+ the max value , min value , avg over the period;

(the TEST chart works only is one month is selected.... which is not what I want)

[martin59]

Hello,

Look at the attached file.

Martin

[#3]

GREAT!!!!!

THANK YOU

Alex