The following report was created in Report Studio using a relational package and shows revenue by sales rep, city, and country. What will the report show if the author creates a detail filter for Revenue>500,000 and applies the filter BEFORE auto aggregation?
A. Only reps who generated total revenue greater than 500,000.
B. Only cities that generated total revenue greater than 500,000.
C. Only countries that generated total revenue greater than 500,000.
D. Only reps who had individual sales transactions of greater than 500,000.
Answer:D
The following report was created in Report Studio using a relational package and shows revenue by sales rep, city, and country. What will the report show if the author creates a detail filter for Revenue>500,000 and applies the filter BEFORE auto aggregation?
A. Only reps who generated total revenue greater than 500,000. B. Only cities that generated total revenue greater than 500,000. C. Only countries that generated total revenue greater than 500,000. D. Only reps who had individual sales transactions of greater than 500,000.