Multiple choice technology

Report has the following Attribute - Category, SubCategory and a Metric - Sales. If Total sales for all the subcategories displayed in the report need to be calculated then filtering and grouping should be respectively set as

  1. Ignore, None

  2. Absolute, None

  3. Standard, None

  4. Absolute, Standard

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

To calculate total sales for all displayed subcategories, filtering should be Standard (includes all subcategories visible after filters) and grouping should be None (no hierarchical aggregation). This combination sums all displayed subcategory values at the report level.