that Excel file.

$($Click the icon to view the Excel worksheet.$)$

Read the requirements.

What was the total sales revenue for each product group? the dropdown list. If an area of the report does not need any Pivot table fields, leave the input fields empty.$)$

$\backslash$table$[[$Filters$,$Column,,$],[$Rows$,$Values,$\backslash$table$[[$What type of calculation you would use$],[$to summarize the value field$]]],[$:$.,,$Summarize value field by sum,grad