Date Sum of Sale Sales RepresenSum of Sale

1/4/2024 1193.6 Amit 31727.93

1/13/2024 1042.65 John 30479.41
1/14/2024 2031.16 Karan 21146.88
1/16/2024 1587.3 Priya 21496.74
1/17/2024 1548 Rina 20612.02
1/23/2024 3274.44 Sana 28036.15
2/14/2024 3410.66 Total Result 153499.13
2/17/2024 6246.6
2/19/2024 1665.44
2/22/2024 4260.78
2/27/2024 8694.11
3/12/2024 1574.95
3/20/2024 3317.4
3/22/2024 1756.2
4/11/2024 240.84
4/20/2024 3560.8
4/21/2024 6156.54
4/22/2024 6816.04
4/24/2024 6073.16
4/29/2024 807.75
5/5/2024 2534.7
5/15/2024 1223.18
5/20/2024 2165.61
5/22/2024 4908.54
6/21/2024 4607.94
6/23/2024 3929.64
6/25/2024 3636.7
7/2/2024 9294.42
7/13/2024 3330.02
8/2/2024 591.02
8/4/2024 6042.89
8/17/2024 1001.28
8/23/2024 533.61
9/15/2024 2637.12
10/6/2024 12951.52
10/14/2024 6469.5
10/28/2024 4481.2
10/29/2024 2506.38
11/4/2024 1113.2
11/5/2024 1816.08
11/23/2024 1919.2
11/28/2024 6506.76
12/12/2024 1408.89
12/23/2024 1750.84
12/25/2024 880.47
Total Result 153499.13
Product Sum of Sale Category Sum of Sale
AquaFresh 8005.82 Energy Drink 31944.74
ColaMax 15903.83 Juice 46648.76
EnergyX 9269.01 Soda 51636.65
FizzUp 35732.82 Water 23268.98
MangoRush 25275.18 Total Result 153499.13
OrangeBliss 21373.58
PowerBoost 22675.73
PureDrop 15263.16
Total Result 153499.13
City Sum of Sale
Ahmedabad 12953.5
Vadodara 22472.75
Amritsar 30160.41
Bangalore 7562.23
Chandigarh 8857.38
Cochin 19965.37
Kolkata 34557.76
Pune 16969.73
Total Result 153499.13
 This shape represents a slicer. Slicers are supported in Excel
2010 or later. 10000

9000
If the shape was modified in an earlier version of Excel, or if
the workbook was saved in Excel 2003 or earlier, the slicer 8000
cannot be used.
7000

6000

5000

4000
This shape represents a slicer. Slicers are supported in Excel
2010 or later. 3000

If the shape was modified in an earlier version of Excel, or if the 2000

workbook was saved in Excel 2003 or earlier, the slicer cannot 1000
be used.
0
45295 45304 45313 45322 45331 45340 4

This shape represents a slicer. Slicers are supported in Excel

2010 or later. Total
If the shape was modified in an earlier version of Excel, or if 160000
the workbook was saved in Excel 2003 or earlier, the slicer
cannot be used. 140000

120000

100000

80000

60000
This shape represents a slicer. Slicers are supported in Excel 2010 or 40000
later.
20000

If the shape was modified in an earlier version of Excel, or if the 0

Amit John Karan Priya
workbook was saved in Excel 2003 or earlier, the slicer cannot be
used.

Total
This shape represents a slicer. Slicers are supported in Excel 2010 or
later.

If the shape was modified in an earlier version of Excel, or if the

workbook was saved in Excel 2003 or earlier, the slicer cannot be
used.
 Total

AquaFresh
ColaMax
EnergyX
FizzUp
MangoRush
OrangeBliss
PowerBoost
PureDrop
Total Result

304 45313 45322 45331 45340 45349 45358 45367

Total Total
000 Total Result

000 Pune

000 Kolkata

000 Sum of Sale Cochin

Sum of Sale
000 Chandigarh

000 Bangalore

000 Amritsar

000 Vadodara

0 Ahmedabad
Amit John Karan Priya Rina Sana Total
Result 0 50000 100000 150000 200000

Total

Energy Drink
Juice
Soda
Water
Total Result
Total Result
tal

AquaFresh
ColaMax
EnergyX
FizzUp
MangoRush
OrangeBliss
PowerBoost
PureDrop
Total Result

tal

Sum of Sale

150000 200000
Date Month Sales RepresentativeCategory Product
1/4/2024 January Sana Soda ColaMax
1/13/2024 January John Juice OrangeBliss
1/14/2024 January Sana Juice OrangeBliss
1/16/2024 January John Juice MangoRush
1/17/2024 January John Juice OrangeBliss
1/23/2024 January John Energy Drink PowerBoost
2/14/2024 February Karan Energy Drink PowerBoost
2/17/2024 February Sana Juice MangoRush
2/17/2024 February Karan Juice MangoRush
2/19/2024 February Rina Water AquaFresh
2/22/2024 February Rina Soda FizzUp
2/22/2024 February Priya Soda ColaMax
2/27/2024 February John Soda FizzUp
3/12/2024 March Amit Soda ColaMax
3/20/2024 March Sana Juice OrangeBliss
3/22/2024 March Karan Juice MangoRush
4/11/2024 April John Energy Drink EnergyX
4/20/2024 April Amit Juice OrangeBliss
4/21/2024 April Rina Water PureDrop
4/22/2024 April Priya Juice MangoRush
4/24/2024 April Sana Juice MangoRush
4/29/2024 April Amit Water AquaFresh
5/5/2024 May Amit Soda FizzUp
5/15/2024 May Amit Juice OrangeBliss
5/20/2024 May Sana Energy Drink EnergyX
5/22/2024 May Amit Juice MangoRush
5/22/2024 May Sana Energy Drink EnergyX
6/21/2024 June Amit Soda FizzUp
6/23/2024 June Priya Juice OrangeBliss
6/25/2024 June Amit Energy Drink EnergyX
7/2/2024 July Amit Soda FizzUp
7/13/2024 July Rina Juice OrangeBliss
8/2/2024 August priya Soda FizzUp
8/4/2024 August Sana Water AquaFresh
8/4/2024 August Amit Juice OrangeBliss
8/17/2024 August Karan Energy Drink PowerBoost
 8/23/2024 August Amit Soda FizzUp
9/15/2024 SeptemberKaran Water PureDrop
10/6/2024 October Karan Soda ColaMax
10/6/2024 October Rina Energy Drink PowerBoost
10/14/2024 October Priya Water PureDrop
10/28/2024 October Karan Soda FizzUp
10/29/2024 October John Soda FizzUp
11/4/2024 November Karan Juice MangoRush
11/5/2024 November Rina Soda ColaMax
11/23/2024 November John Soda FizzUp
11/28/2024 November John Energy Drink PowerBoost
12/12/2024 December John Energy Drink PowerBoost
12/23/2024 December John Soda ColaMax
12/25/2024 December Amit Water AquaFresh
Units Sold Price per Unit Sale City
20 59.68 1193.6 Kolkata
15 69.51 1042.65 Vadodara
58 35.02 2031.16 Kolkata
55 28.86 1587.3 Vadodara
30 51.6 1548 Cochin
39 83.96 3274.44 Chandigarh
37 92.18 3410.66 Kolkata
60 89.62 5377.2 Amritsar
27 32.2 869.4 Pune
56 29.74 1665.44 Amritsar
24 23.76 570.24 Chandigarh
58 63.63 3690.54 Pune
97 89.63 8694.11 Kolkata
65 24.23 1574.95 Pune
90 36.86 3317.4 Cochin
30 58.54 1756.2 Ahmedabad
12 20.07 240.84 Pune
40 89.02 3560.8 Vadodara
78 78.93 6156.54 Amritsar
77 88.52 6816.04 Cochin
61 99.56 6073.16 Kolkata
25 32.31 807.75 Kolkata
85 29.82 2534.7 Ahmedabad
14 87.37 1223.18 Cochin
37 58.53 2165.61 Amritsar
62 27.14 1682.68 Chandigarh
62 52.03 3225.86 Ahmedabad
61 75.54 4607.94 Cochin
78 50.38 3929.64 Bangalore
41 88.7 3636.7 Amritsar
93 99.94 9294.42 Vadodara
62 53.71 3330.02 Chandigarh
58 10.19 591.02 Pune
64 72.69 4652.16 Amritsar
47 29.59 1390.73 Ahmedabad
16 62.58 1001.28 Bangalore
33 16.17 533.61 Cochin
82 32.16 2637.12 Ahmedabad
94 62.53 5877.82 Kolkata
95 74.46 7073.7 Pune
95 68.1 6469.5 Kolkata
68 65.9 4481.2 Vadodara
74 33.87 2506.38 Vadodara
46 24.2 1113.2 Pune
94 19.32 1816.08 Pune
80 23.99 1919.2 Cochin
97 67.08 6506.76 Amritsar
21 67.09 1408.89 Ahmedabad
26 67.34 1750.84 Bangalore
81 10.87 880.47 Bangalore