getting Weekly max Date's value by set analysis

[#1]

Dear Team/

i want to get the weekly max date value in table by using set analysis. like

each week have 4-5 working days. on each week i have to identify the max date of that week and get the value on that week.

below is the screenshot

Expression: Sum({<[Trading Date]={'$(=max([Trading Date]))'}>} [Close Rate])

[aveeeeeee7en]

Try something like this:

LOAD
Week_NewDate,
Max(NewDate) AS Date_New,
SUM(Amount) AS Amount_New
GROUP BY Week_NewDate;

LOAD *,
Week(NewDate) AS Week_NewDate;

LOAD *,
NUM(RAND()*1000,'#,##0.0') AS Amount;

Dates:
LOAD
date(makedate(2015,05,01)+Recno()-1,'DD/MM/YYYY') as NewDate
AUTOGENERATE 46;

Regards

Av7eN

[#3]

Thanks to all of you who ever help me in this. i have already resolve this issue by using join at script level

[#4]

Close the discussion with marking helpful or correct answer.