CODEWITHSUNDEEP
sortingreporting-servicesreporting
AGuyCalledGerald
AGuyCalledGerald

Reputation: 8150

Sort Report table by totals

I have built a report with a table. It looks very much like the table in the following link (last figure, before "Next Steps").

Microsoft Tutorial: Adding grouping and totals

I have turnover values for products which are grouped by subcategories and categories and have a total for subcategories and categories. I want to sort the table by turnover (in the example it is "line total"). I can do that for the single product values in a subcategory, but not for the totals. Is that possible?

Upvotes: 0

Views: 58

Answers (1)

AGuyCalledGerald
AGuyCalledGerald

Reputation: 8150

For all people interested: the row groups can be sorted by themselves (in Row Group - Group Properties). As the sort expression, one has just to choose SUM(Fields.LineTotal.Value).

Upvotes: 0

Related Questions