A report author has applied a Union set operation on two queries with the resultant query named Main_Query containing the data items: Product line, Order method/Region, Revenue and Unit Sale Price. The report author added the data items to the list, grouped on Product line and Order method/Region. The screenshot below shows the result:

What must the report author do for the report to look like the following?

A. Set the detail aggregation property to Automatic for each field.
B. Set the detail aggregation property to None for product line and order method. Total for Revenue. Average for Unit Sale Price.

C. Set the detail aggregation property to None for only Product Line and Order Method. Automatic for Revenue. Average for Unit Sale Price.

D. Set the detail aggregation property to Default for product line and Order method. Default for Revenue and Average for Unit Sale Price.