I am trying to create an MDX query that returns for all sales
represenatives, the name of their best sales month and the amount they
sold that month.

I have a time dimension, a sales person dimension and a measure of
sales.

How can I retrieve the name of the best month for each person and the
amount of sales for that month?

Thanks in advance,
HvdM