the max method in set analysis

[#1]

Hi all members

i have one problem

i use like this exemple

Task	DateTask
T1	13/12/2015
T1	01/12/2015
T1	03/10/2014
T2	01/01/2016
T2	03/01/2016
T3	06/01/2016

i want to load the max date for any Task like

Task	DateTask
T1	13/12/2015
T2	03/01/2016
T3	06/01/2016

i used a variable vMaxDate=date(max(DateTask)) ( i wrote =  )

but the result is not OK, when i select one row in chart table i get the good value ,but in the first display for all values it desplay one values of all rows

Tache	Date
T1	13/01/2016
T2	13/01/2016
T3	13/01/2016

how can i do

thanks all

[#2]

Hi all member and thanks for your answer

it doesn't work with my script i Used a pivot Table in expression not dimenssion

this Tache is a concatination between other field, and join it with other table :

for the first  table:

load

Distinct NameTache&'-'typeTask as Tache,

(MakeDate(1900+left(DateTask,3))+mid(DateTask,4)-1) as DateTask ;

SQL SELECT

,

NameTache,

typeTask,

DateTask   // the max methode doesn't work here max(DateTask) as dateMax  an error message apear  that we cann't put the max methode

FROM "database" ;

-------------------------------------------------------------------

for the second  table:

load

Distinct NameTacheee&'-'typeTaskeee as Tache,

SQL SELECT

NameTache,

typeTask,

FROM "database" ;