Scribd
Upload
21 views1 page

Sales Data Pivot Analysis

The document provides a dataset of sales transactions including dates, product types, sellers, list prices, actual prices, quantities sold, and regions. It instructs the user to create a Pivot Table and a Pivot Chart to analyze the data. The focus is on comparing list prices and actual prices across different regions.

Uploaded by

Kashish Premwani
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
21 views1 page

Sales Data Pivot Analysis

The document provides a dataset of sales transactions including dates, product types, sellers, list prices, actual prices, quantities sold, and regions. It instructs the user to create a Pivot Table and a Pivot Chart to analyze the data. The focus is on comparing list prices and actual prices across different regions.

Uploaded by

Kashish Premwani
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

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

You might also like