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
-
Ignore, None
-
Absolute, None
-
Standard, None
-
Absolute, Standard
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.