Scribd
Upload
8 views6 pages

Sales Report by Product and City

The document presents sales data for various products across different cities, detailing sales representatives, units sold, prices, and total amounts. The total sales amount is 643,500, with significant contributions from categories like laptops, PCs, and mobiles. Key sales representatives include James, Mathew, and Tara, with Bangalore and Chennai being the top-performing cities.

Uploaded by

naandish25
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
8 views6 pages

Sales Report by Product and City

The document presents sales data for various products across different cities, detailing sales representatives, units sold, prices, and total amounts. The total sales amount is 643,500, with significant contributions from categories like laptops, PCs, and mobiles. Key sales representatives include James, Mathew, and Tara, with Bangalore and Chennai being the top-performing cities.

Uploaded by

naandish25
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

Date Product Category Sales Rep City No of Units Price Amount

1/9/2025 Dell Laptop Tara Delhi 3 3500 10500


7/9/2025 HP PC Mathew Bangalore 3 1500 4500
6/9/2025 Dell Laptop James Bangalore 9 6000 54000
7/9/2025 One Plus Mobile Mathew Delhi 6 3500 21000
7/9/2025 HP PC Mathew Bangalore 11 4500 49500
4/9/2025 Dell Laptop Tara Chennai 5 3500 17500
7/9/2025 One Plus Mobile Tara Bangalore 2 1500 3000
7/9/2025 HP PC James Bangalore 1 3500 3500
7/9/2025 HP PC Mathew Mumbai 5 1500 7500
7/9/2025 Dell Laptop Mathew Bangalore 6 3500 21000
7/9/2025 HP PC James Bangalore 3 1500 4500
7/9/2025 Dell Laptop Tara Mysore 5 3500 17500
7/9/2025 One Plus Mobile Mathew Mysore 8 3500 28000
2/9/2025 HP PC Tara Mysore 2 6000 12000
4/9/2025 HP PC Mathew Chennai 7 6000 42000
7/9/2025 Dell Laptop James Chennai 15 3500 52500
7/9/2025 HP PC James Chennai 25 3500 87500
7/9/2025 One Plus Mobile James Bangalore 1 6000 6000
7/9/2025 Dell Laptop Mathew Chennai 8 3500 28000
3/9/2025 One Plus Mobile Mathew Chennai 21 6000 126000
7/9/2025 HP PC James Mumbai 3 3500 10500
5/9/2025 HP PC Mathew Mumbai 8 3500 28000
7/9/2025 Dell Laptop Tara Mumbai 6 1500 9000
City Sum of Amount Product Sum of Amount Sales Rep
Bangalore 146000 Dell 210000 James
Chennai 353500 HP 249500 Mathew
Delhi 31500 One Plus 184000 Tara
Mumbai 55000 Total Result 643500 Total Result
Mysore 57500
Total Result 643500
Date - all -

Sum of Amount Category Sum of Amount Sum of Amount


218500 Laptop 210000 643500
355500 Mobile 184000
69500 PC 249500
643500 Total Result 643500
Sales by City

Bangalore Chennai Delhi Mumbai Mysore Total Result

Productwise sales

Dell HP One Plus Total Result


C:\Users\Nandish\Desktop\SAMPLE PROJECT [Link] SAMPLE PROJECT 2
C:\Users\Nandish\Desktop\Work Book 1 Table [Link] SAMPLE PROJECT 2
C:\Users\Nandish\Desktop\SAMPLE PROJECT [Link] SAMPLE PROJECT 2

You might also like