Sort on Summarized field in a report
Hello, I have a spreadsheet with a bunch of columns. I created a report that groups the data by "Client Servicer" where "Submitted" equals N and "Expiration Date" is in the past. The report also Summarizes the data by summing up the "Annual Premium" amount for each Client Servicer.
There are over 100 different Client Servicers who meet the above criteria in the report. I was hoping to be able to sort on the summed up Annual Premium amount (is this possible?) and then pull onto a dashboard, the top 20 Client Servicers with the largest summed up Annual Premium amounts. Is this possible? In the report, I sorted by Annual Premium but it sorts the individual rows for each individual Client Servicer and doesn't actually sort the report by the summed up Annual Premium amount for the Client Servicers.
Thanks in advance for your help!!