Question

The Excel file Store and Regional Sales Database provides sales data for computers and peripherals showing the store identification number, sales region, item number, item description, unit price, units sold, and month when the sales were made during the fourth quarter of last year.3 Modify the spreadsheet to calculate the total sales revenue for each of the eight stores as well as each of the three sales regions.

Answer 1

First of all add a new column "Sales Revenue" by mutlipying the values of column "units sold" and "unit price".

Then for calculating the total revenue for each of the eight stores can be obtained by inserting a pivot table by puting "store identification number" in row field and putting "sales revenue" details in values field, as per below snapshot

For getting Sales Revenue region wise then replace the "Store identification value" in row field with "Sales region" column.