AudienceView Connect
AudienceView Documentation

Sorting Results by Data Not Included as a Result Member

If there is data that you want to use to sort but that is not included as a result member, you can use the sorting options section of the Business Intelligence|Results page to sort.

The following procedure assumes you already have opened an existing BI query or are creating a new one. For more information, refer to the Business Intelligence-Search Page, Performing Searches and Creating a BI Query.

To sort by data not included as a result member, complete the following:

  1. Select the Results tab.
    The Business Intelligence|Results page appears.
  2. Click 'Add Sort'.
    A new row is added to the sorting options section.
  3. Click in the 'Name' column and search for and select the field that you want to use in the sort.
  4. Define how you want to sort by selecting Ascending (A to Z or 0 to 9) or Descending (Z to A or 9 to 0) from the 'Type' dropdown.
  5. For each field that you want to use to sort, repeat the process from Step 2.
  6. To preview your changes, select the Preview tab.
    The Business Intelligence|Preview page appears.
  7. To extract to Microsoft Excel or PDF, refer to Running a Saved Query
  8. If you want to save your changes, expand the save lists and extracts section of the Business Intelligence|Results page and save your changes. For more information, refer to Saving a BI Query.