From: sensible.anita on
The solution must be very very simple as I just can't find an answer
to my problem.

I have a dataset that returns year, weeknumber and amount. I display
this in a chart. So far so good.
However, I need to display next to the chart, the highest amount and
the week of the highest amount.

I don't have a problem displaying the highest amount as I just use the
Max function. However, I have the hardest time returning the week of
the highest amount. How can I do that? I'm fairly new to reporting
services so forgive me if the answer is very obvious.