I've created a Matrix...basically it looks like this Customer 2010 2011 Joe $50 $30 Steve $75 $0 Frank $60 $10 I want it to sort by the $ amount from highest to lowest, which it is doing, but its currently doing it based on the TOTAL $ amount of 2010 +2011. I want it to do sort by the $ amount of 2011 only...suggestions? I have the user enter a start year and end year as paramaters, so to be more specific I want the sorting done by $ amount for whatever the endyear paramater is... I have the sorting on the customer name to sort by Fields!Sales.Value

Hi WhoIsHomer, Thanks for your detail sample report's layout with data, We could understand your requirement completely. Actually, we could achieve this requirement by setting a sort to row group. For detail steps, please follow these: 1. Right-click Customer in Row Group Panel at the left-bottom of your screem. Note: Customer is the name of your row group. 2. Select Group Properties..., then move to Sorting tab. 3. Click Add button, the type in an expression =SUM(IIF(Fields!Year.Value=Parameters!EndYear.value,Fields!Sales.Value,nothing)) 4. To order, please select Z to A 5. Click OK After top steps, I think you could sort the last year by Sales. Thanks, Challen Fu Please remember to mark the replies as answers if they help and unmark them if they provide no help.

Perfect, thanks so much, that worked great!