Chart ordering in SSRS based on SSAS OLAP cube. - drolaw

Hello,
All of the software below is SQL server 2005 SP2 running on a WIN
XP Professional SP2 box:

I am new to SSRS and I'm attempting to create some charts based off of
OLAP cubes I have created in SSAS. I am comparing the functionality to
Crystal to see if this is a better fit for my company. Anyway, I have
been able to get everything working except for one semmingly simple
thing: sorting.

I have created a bar chart that displays the segment share in dollars
per product category and classification. This is working very well,
but the bars are not in the correct order. What I want is a chart that
displays the categories in descending order by the sum of dollar
sales. Right now, it displays them in alphabetical order.

Basically, I want the TOP N functionality that Crystal offers that
allows me to order the results by the sum of dollar sales for each
category as opposed to the name of each category.

I tried looking at the top N filtering on the chart level, but it did
not work. I don't see any sorting options anywhere else and I have
googled this for over an hour to no avail.

Any suggestions are appreciated.

Thanks,
Dave