1. Set the Sort Key to sort by last name.
    1. Select Tools, User Options from the menu bar.
    2. Select the Query tab.
    3. Select 'Last, First Middle' or 'Last, First M.' in the Constituent name field drop-down menu and click OK.
  2. Create a constituent query to select the appropriate constituents. Select Constituent Information, Sort Key as one of the output fields.
  3. Create the pivot report in The Raiser's Edge.
  4. Use Sort Key in the Pivot Report to sort the list alphabetically by last name.