Grouping within a row report


I have a row report set up to pull data from multiple sheets. I have charts created off of the row report and cannot get the columns to arrange in a largest to smallest order. In the report, the grouping and filtering will only allow me to sort by site name alphabetically, not by total summary. Is it possible to rearrange the report or chart?