Set analysis for max date value?

[#1]

There is month name and week name for each date. when i select month i need the value for max date.

Ex- For August i need the value for max date(i.e 31st August)  as in database

Thanks in advance,

Soumya

[kavita25]

Check the qvw

[#3]

Not aggregation

when we click on month dimension its showing correct only 

But By default means if i cleared everything  its showing max date i e 9/6/2015(Sep month) and value of that max date

I dont want like that. what i need is by default july (max date) - value (max date)

                                        aug(max date) - value(max date )

                                        Sep(max date) - Value(max date)

[#4]

Here is the sample qvw file and Excel

Can u do it in mine ?

I m not understanding from ur file

Thanks,

Soumya

[kavita25]

Check the file

[Anonymous]

I donot see your file

maybe this way?

aggr(sum({$<my_date={"$(=max(my_date))"}>}Metric),my_date)-sum({<my_date={"=$(=max(mydate))}">Metric)