Loading

Alternate Methods of Excluding a Specific Value

Дата публикации: Apr 7, 2026
Задача
How to exclude a single value from a worksheet when an Exclude filter does not provide desired results.
Действия

Option 1: Create a Set

  1. Right-click on the desired dimension and select Create Set.
  2. Name the set.
  3. Exclude the desired members.
  4. Click OK.
  5. Place the newly created set on the Filters shelf.
  6. Place the set on the Rows or Columns shelf, as desired.

Option 2: Create a Calculated Field

  1. Select Analysis > Create Calculated Field....
  2. Name the field as desired.
  3. Place the following formula into the formula window:
    IIF([measure]=0, 'Exclude', 'Include')
  4. Click OK.
  5. Place newly created calculated field on the Filters shelf.
  6. Select desired filter option, Exclude or Include.
Дополнительные ресурсы
Create Sets
Номер статьи базы знаний

001458190

Вложения

sampleExcludeFilter.twbx

13 KB

 
Загрузка
Salesforce Help | Article