Not all data is shown but pleaseee give thorough steps on how to solve each part

help.

c. You are given 472 sales transactions for a day for an online retalier that sells books and OVDs. Buld 4 PivotTables showing the following: a) total revenwe by product (rows) and rejion (columns), show in whole dollars (e.8., 51,234) b) for each region, what % of the revenues came from Books and what % of revenues came from DVD's (show in X with 1 decimal digit, e.e., 12.3\%) c) number of transactions by product and region d) \% breakdown of count of book and OVD purchases in each region (for each region, show what % of the transactions for books and what % were for DVOs). (show in $ with 1 decimal digit, e.g., 12.3\%) Mint on (b) and (d): Notice in (b) we are looking at S revenves and in (d) we bok at the count of transactions. For example, suppose in East, 60 transactions had books with total revenue $3000 and 40 transactions were for DVD's with total revenue of $1000. Then in (b), the column for East should have 3000/4000 75W from books and 1000/4000=25N from DVO's. In (d), the column for East should have 60/10060% frem books and 40/100=40% from 0 VVo's. c. You are given 472 sales transactions for a day for an online retalier that sells books and OVDs. Buld 4 PivotTables showing the following: a) total revenwe by product (rows) and rejion (columns), show in whole dollars (e.8., 51,234) b) for each region, what % of the revenues came from Books and what % of revenues came from DVD's (show in X with 1 decimal digit, e.e., 12.3\%) c) number of transactions by product and region d) \% breakdown of count of book and OVD purchases in each region (for each region, show what % of the transactions for books and what % were for DVOs). (show in $ with 1 decimal digit, e.g., 12.3\%) Mint on (b) and (d): Notice in (b) we are looking at S revenves and in (d) we bok at the count of transactions. For example, suppose in East, 60 transactions had books with total revenue $3000 and 40 transactions were for DVD's with total revenue of $1000. Then in (b), the column for East should have 3000/4000 75W from books and 1000/4000=25N from DVO's. In (d), the column for East should have 60/10060% frem books and 40/100=40% from 0 VVo's