Sorting report by grand total from report footer

[Soboths]

I have a report that listed and sorted by Product Category ID, Product#, and
$Sale by each product. At the product Category ID footer, I also have a
SumOf$Sale by Product Category ID. I would like to have my report sort by the
SumOf$Sale, which is the result of each product category ID from product
category footer in descendent but still keep together with its product
category ID. Is there a way to do this?

Thanks for any help in advance.

 

[Marshall Barton]

I have a report that listed and sorted by Product Category ID, Product#, and
$Sale by each product. At the product Category ID footer, I also have a
SumOf$Sale by Product Category ID. I would like to have my report sort by the
SumOf$Sale, which is the result of each product category ID from product
category footer in descendent but still keep together with its product
category ID. Is there a way to do this?

Yes, but there is no way to sort a report by a value that is
calculated within the report. You need to calculate the sum
in the report's record source query.

 

[Soboths]

Thanks for your help Marsh.

Yes, but there is no way to sort a report by a value that is
calculated within the report. You need to calculate the sum
in the report's record source query.