Multiple choice technology

Report has the following Attribute - Category, SubCategory and a Metric - Sales. If filtering and grouping is set to standard then the sales metric is calculated as

  1. At category level, including only subcategories displayed

  2. At category level, for all subcategories displayed

  3. Total sales for the subcategories displayed on the report

  4. Total sales for all subcategories displayed on the report

Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

With standard filtering and grouping, the Sales metric calculates at the Category level (parent attribute) and includes only the SubCategory records that are actually displayed in the report after filtering is applied. It excludes filtered-out subcategories from the aggregation.