June 10, 200520 yr I want to know, is there a way to generate a list (ascending order) from the calcualted values of a subsort on a report. Example, Person A had 5 choc cookies, Person A has 6 Sugar Cookies totaling 11 cookies. 20 People. Thank you in advance for your help.
June 13, 200520 yr Author Alright, let me try this again then. If I create a report that subsorts the data with a total field. i.e. Denver ordered three chocolate cookies and 6 red cookies for the month of June totaling 11 cookies. There were thirty different cities that are being tracked. Is there a way to create a report based on that information that would list the cities total orders in a descending order?
June 13, 200520 yr When defining the sort order for the report, select 'Reorder based on summary field', specify the summary field that totals the number of cookies, then select 'Descending order'.
Create an account or sign in to comment