Question

it generates a sub total to summarise the data​

Answer 1

The subtotal summary will get created in Microsoft Excel.

...

Go to data Tab, and select Subtotal from the Outline group.

Subtotal dialog box will appear.

Select year from the drop down list of 'At each change in'.

To add the fields, select Sum from the function drop down list.

Check to Revenue, and click on OK.

Answer 2

Explanation:

subtotal is the correct answer