The Universal Containers Sales team is looking to build a dashboard that shows the total revenue from their top 10 accounts (based on revenue) and make it dynamic with the filters of the dashboard. What two steps are required to accomplish this? (Choose two.)

A. Create a query with a selection based interaction as a filter using the limited query to pass in the 10 Account Id's.
B. Create a query and sort descending by revenue and limit it to 10 results.
C. Create a query that groups by Account Id and sorts descending by revenue and limit it to 10 results.
D. Create a query with a results based interaction as a filter using the limited query to pass in the 10 Account Id's.

Suggest answer: AC

Reference: