🎴 Flashcard Mode
Database Technology and Oracle Developer Tools
Card1 / 20
Mastered0
Review0
QuestionClick to flip
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
AnswerClick to flip back
A
Standard, None
💡 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.