Find the Largest Sales Order Amount and its Date of Sale

Solution: 1. Navigate to Lists > Search > Saved Searches > New. 2. Click the Transaction link from the list. 2. Under Criteria tab > Standard subtab, add the following filters:     - Type is Sales Order      - Main Line is true 3.  Under Results tab, click the Remove All button and add the following fields under Columns subtab:     • Field = Formula (Date)            - Summary Type = Maximum            - Formula = max({trandate}) keep(dense_rank last order by {totalamount})     • Field = Amount           - Summary Type = Maximum 4.  Click Save & Run.