I have a report that looks through a single field in a table. I am trying to have the report group and tally up all simliar products and provide a percentage for each item based on the total items in the report.
I have it working but grouping on the product, and having a text box dividing the toal group cound (grouping by item) by the count(*) of all items in the report which is in the foter of the report amount to get a percent. =Format(Count(*)/[TotalCount],"00.0%")
Only issue is that I would liek to sort by this item percent text box value so I can see largest to least products counts in the table.
How can I sort the report based on the text box item percentage or should I be using another method?