Filter Column Data

Filter the contents of a column in the Spreadsheet View to find specific information or the absence of information. Column filters are available on the following screens:

  • Insight - Spend
  • Insight - GTIN
  • Content Management - Duplicate Resolution
  • Content Management - Description Generation - Abbreviations
  • Content Management - Description Generation - Abbreviations Analysis
  • Content Management - Review & Approval
  • Virtual Item Master
  • Configuration - Mappings
  • User Admin

  1. Start in the Spreadsheet View.

  2. Click the header of the column you want to filter.

  3. Click Filter.
  4. Type the desired term in the Filter field.
  5. Click Filter. The column header changes to orange to show the presence of a filter.
  1. Click the header of the column you want to filter.
  2. Click Blank to view items that do not have data for this attribute.

  3. Click Not Blank to view items that do have data for this attribute.
  1. Click Clear Filters to remove filters from all columns.
  2. Click the header of a filtered column to clear a single column filter.
  3. Click Filter.
  4. Click Clear.