C: Create a new tab named M1C. Create a table and bar chart to show revenue by distributor and wine var Wine varity revenue by distributor Data Destination Sum - Red Wine Case Sum - White Wine Case RSum - Organic Wine Case Revenue Oakland CA 5,572,710.00 $ 5,944,224.00 $ 762,912.00 Portland OR 4,360,320.00 4,651,008.00 1,215,360.00 Riverside CA 5,642,100.00 6,018,240.00 $ 766,656.00 Seattle WA 5,561,190.00 5,931,936.00 $ 775,584.00 Total Result 21,136,320.00 $ 22,545,408.00 $ 3,520,512.00 Rationale: Utilizing the create pivot function the above pivot table was created from the raw data set in the data tab of this workbook. The piviot table shows the revenue for each wine varity by distributor. To get the wine varity revenue three columns were added to the data. The revenue was calculated using the whole sale case price data for each varity listed on the Cost&Distances tab of this workbook. A bar chart was created from the selected data in the piviot table to display the four distributors graphically with their revenue by variety. This was done to clearly display the different revenue amounts between the diffrent varieties and distributors. The chart shows that Seattle, Riverside and Oakland still have similiar trends for revenue in Red and White wine with White wine showing the most revenue for each. It also shows Portland is nearly 2 million less in revenue which we can tie back to a smaller sales volume but their organic revenue is higher as expected