"Bucky" <uw_badgers@mail.com> wrote in message
news:1108522845.968590.268290@c13g2000cwb.googlegroups.com...
> In a drilldown report, is it possible to sort by an aggregated column
> like total? Here's an example of what I mean. I would like the final
> report to sort by TOTAL in descending order.
>
> original data set:
>
> region state sales
> ------ ----- -----
> East NY 500
> East MA 100
> West CA 700
> West WA 200
>
> After drilldown/grouping:
>
> region total
> ------ -----
> East 600
> West 900
>

Robert Bruckner [MSFT] wrote:
> You can use aggregate functions for sorting data. E.g. you can sort
by
> =Sum(Fields!Sales.Value)
> Does this provide what you are looking for?