Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

17. Go to the Product Pricing worksheet. For each product and customer, Sandra wants to compare the unit price with the average discounted price, starting

17. Go to the Product Pricing worksheet. For each product and customer, Sandra wants to compare the unit price with the average discounted price, starting with products that have the most orders. She also wants to display the product pricing data by month. To provide this information, modify the Product Pricing PivotTable as follows: a. Sort the PivotTable based on the Sum of Quantity field, sorting from Largest to Smallest and Top to Bottom. b. Add the Discounted Price field to the bottom of the Values area of the PivotTable. c. Change the Value Field Settings for the Sum of Discounted Price values to determine the Average discounted prices. d. Change the number format of this field to Accounting with 2 decimal places and the $ symbol. e. Add the Date field to the Filters area of the PivotTable. f. Filter the Product Pricing PivotTable to display January order data only

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Ziglar On Selling The Ultimate Handbook For The Complete Sales Professional

Authors: Zig Ziglar

1st Edition

0785288937, 978-0785288930

More Books

Students also viewed these Finance questions