Working with Filters

With filters and saved views, you have control over how data appears in the grids.

  1. Navigate to either Profitability > Customer Profitability or Pricing.
  2. Verify that All Relationships appears in the My Saved Views drop-down list.
    This default view shows all the unfiltered data in the grid.
  3. Select Filters.

    The Filters dialog box opens.


    Filters dialog box.

  4. Select Or to change the filter relationships, if needed.
  5. Select the column that you want to filter in the Select Column drop-down list.
  6. Select one of the Select Filters options.
    Filtering choices can vary depending on the selected column. For example, when the column data is amounts or rates, the filter options are Equals, Does Not Equal, Greater than or Equal, and Less than Equal.
  7. Enter an appropriate value for the column in the Enter Value field.
  8. Select "" Add to add additional filter rows as needed.
    You can use the "" Delete option to remove filter rows if needed.
  9. Select Apply to filter the grid by your defined criteria.
    The grid is sorted appropriately, and a notice appears above the grid showing the filter that is in use. You can select the notice to remove or modify the filter.
  10. Select Save As New View.
    The Save As New View dialog box opens.
  11. Enter a View Name.
  12. Select Save to close the dialog box and return to the grid.
The name of the new filtered view appears in the My Saved Views drop-down list.
You can select Save As New View to change the name of the current saved view. Select "" Delete to remove the saved view that you are currently using.