Set

[#1]

Hi Guys

I have a data in Excel in following format

Date            ExchangeRate   Day

10/8/2012      42.34                   monday

11/8/2012       45.54                    Tuesday

.

.

.

.

.

.

.

.

I want the out put in a straight table as

CalendarWeek as Dimension and 2 Expression

First  Max(ExchangeRate) for Weeks and

Second expression as Corresponding Day of the Maximum Exchange Rate for a particular Week

For Example

CalendarWeek              Max(ExchangeRate)      Day

1                                             45                           Tuesday

2                                               43.34                        Saturday

3                                               46                              Monday

I want to achieve this by using Set Expression

Please Help