Problem $2$: To help us track customer sales we are going to produce a report called

Sales By Customer By Product Value. Create a report that looks like the one depicted on

pages $3$&$4$ of this homework. These pages show the first and last pages of the report.

The format of this report will be a little unusual. For each customer we want to know the

total dollar amount the customer has bought at the top and then the amount the customer

has spent on each inventory item below in descending order. The goal of the report is to

know which inventory items our customers are spending the most money on$.$ The

customers should be listed ascending by customer number. At the very end of the report

we want to show the total dollar sales of the entire inventory sold. Before you create the

report first create a query that pulls the necessary information. Save this query as

qryProblem$2.$ Then create the report based on the query and save it as rptProblem$2.$

Sales by Customer by Product Value

please advise how to solve this query and form