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
Get step-by-step solutions from verified subject matter experts
