Straight Table

[#1]

I have a data which has following fields...

Date Day ,Exchange Rate

Now in a straight table i want to show Max Exchange rate ,Day of Max Exchange Rate across CalendarWeeknumber

For Example

6     41     Thursday

7     40     Monday

8      42     Tuesday

[#2]

Hi,

can't you  use Week(Date) as week_num to get the exact week

then use this week_num field and all other existing fields as dimensional fields with max(Exchange rate) as expression

[#3]

thanks for the reply but i want the day on which exchange rate is max for every week??

Suppose in 5th week of the year thursday is the day when exchange rate is max... similarly for other weeks

[#4]

Hi,

WeekDay(Date) will returns the day name say thursday..,

hope this helps

[#5]

use dynamic dimension week(date) and as expression you use weekday({<ExchangeRate = {'$(=max(ExchangeRate))'}>}date)

you might don't need the '' in set analysis just try it out