Question: Create a Pivot Table in a new sheet to the right of Rental Price called Price per Region. This pivot table should compare the total

Create a Pivot Table in a new sheet to the right of Rental Price called Price per Region. This pivot table should compare the total sales price of avocados per region per month. Display the region names. Use a timeline to allow the date range to be dynamically selectable. Place the timeline above the pivot table (inserting rows as needed to move the table). Apply conditional formatting to the sales figures (not the totals) that shows the top 10% of numbers as light green with a green fill, and the bottom 10% of figures as light red with a red fill

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!