Example 5.
4:
Using the given
Date excelsheet create
Producta Pivot table ListPrice
SoldBy and a Pivot Chart toQuantity
ActualPrice compare and
Region
2-Jan-24 Laptops Abhinav 45,000 36,000 4 East
8-Jan-24 Watches Deepak 35,000 28,000 5 North
18-Jan-24 Ipads Dushyant 56,250 45,000 2 West
5-Feb-24 Watches Deepak 28,125 22,500 6 East
16-Feb-24 Iphones Ananya 65,000 52,000 4 Noth
27-Feb-24 Laptops Sukant 60,000 48,000 6 East
28-Feb-24 LG Windo Abhinav 40,000 32,000 7 South
9-Mar-24 Watches Deepak 31,875 25,500 3 West
10-Mar-24 Iphones Sukant 78,750 63,000 2 East
17-Mar-24 IPads Deepak 61,250 49,000 6 South
22-Mar-24 IPads Ananya 58,958 47,166 6 West
3-Apr-24 Laptops Sukant 47,500 38,000 2 North
10-Apr-24 Desktops Dushyant 37,500 30,000 4 West
15-Apr-24 Ipads Sukant 63,125 50,500 8 South
22-Apr-24 Iphones Dushyant 68,750 55,000 4 South
27-Apr-24 Desktops Ananya 40,000 32,000 6 North