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?
To achieve the desired report format, the report author must set the detail aggregation properties appropriately. Specifically, setting the aggregation property to None for the Product Line and Order Method prevents them from being aggregated. Setting the aggregation to Total for Revenue ensures that the values are summed up correctly. Lastly, setting the aggregation to Average for Unit Sale Price provides the expected average values. This adjustment will give the report a detailed aggregation of Revenue totals and an average Unit Sale Price for each Order Method/Region within the Product Line.
correct answer is B ( we shoudn't make the behaviour of aggregation Automatic)
Correct answer is B