0 Replies Latest reply: Aug 10, 2012 1:13 PM by Manish Kukreti RSS

    Set

      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