TOP 3 PRODUCTS BY QTY TOP 3 PRODUCTS BY REVENUE
product Sum of units product Sum of amount
HDD 280 Laptop 10600000
Laptop 265 Mobile 2800000
Mobile 270 TV 6125000
Total Result 815 Total Result 19525000
BOTTEM 3 PRODUCTS BY QTY BOTTEM 3 PRODUCTS BY REVENUE
product Sum of units product Sum of amount
Laptop 265 HDD 840000
TV 245 Mobile 2800000
USBDrive 200 USBDrive 160000
Total Result 710 Total Result 3800000
Salesman Sum of amount Salesman Sum of amount
Amit 3522000 Amit 3522000
Kiran 3613000 Kiran 3613000
Mihir 4420000 Mihir 4420000
Total Result 11555000 Total Result 11555000
region Sum of amount
South 6195000
West 5402000
North 4909000
East 4019000
Total Result 20525000
TOP 3 PRODUCTS BY
TOP 3 PRODUCTS BY REVENUE
QTY 25000000
1000
20000000
Sum of units Sum of amount
500 815 15000000
280 265 270
0 10000000
HDD Laptop Mobile Total 5000000
Result
0
Laptop Mobile TV Total
Result
14000000
BOTTEM 3 PRODUCTS BY 12000000
REVENUE 10000000
4000000
14000000
BOTTEM 3 PRODUCTS BY 12000000
REVENUE 10000000
4000000
8000000
3500000
3000000 Sum of amount 6000000
2500000
2000000 4000000 3522000
1500000
1000000 2000000
500000
0
0 Amit
HDD Mobile USBDrive Total Result
14000000
12000000 11555000
10000000 25000000
8000000 20000000
6000000 15000000
4420000 10000000 6
4000000 3522000 3613000
5000000
2000000
0
So
0
Amit Kiran Mihir Total Result
Sum of amount
12000000
10000000
8000000
6000000 product HDD
Laptop
Mobile
4000000
TV
USBDrive
2000000
0
n b y n l g p t v c lt
Ja Fe Ma Ju Ju Au Se Oc No De esu
lR
ta
To
2000000
0
n b y n l g p t v c lt
Ja Fe Ma Ju Ju Au Se Oc No De esu
lR
ota
T
Sum of amounproduct
date HDD Laptop Mobile TV USBDrive Total Result
Jan 75000 1200000 150000 750000 16000 2191000
Feb 60000 1200000 250000 625000 12000 2147000
May 45000 1200000 250000 500000 12000 2007000
Jun 105000 800000 300000 750000 16000 1971000
Jul 90000 1200000 400000 625000 24000 2339000
Aug 75000 600000 300000 375000 8000 1358000
Sep 105000 1200000 300000 500000 16000 2121000
Oct 75000 1000000 300000 625000 16000 2016000
Nov 105000 1600000 200000 750000 20000 2675000
Dec 105000 600000 350000 625000 20000 1700000
Total Result 840000 10600000 2800000 6125000 160000 20525000
BOTTEM 3 PRODUCTS BY QTY
S BY 800
700
600
500 Sum of units
Sum of amount 400
300
200
100
0
Laptop TV USBDrive Total Result
000000
000000 11555000
000000
000000
000000 11555000
000000
000000
000000
4420000
000000 3522000 3613000
000000
0
Amit Kiran Mihir Total Result
Sum of amount
25000000 20525000
20000000
15000000
10000000 6195000 5402000 4909000 4019000
5000000
0
South West North East Total Result
Sum of amount
product HDD
Laptop
Mobile
TV
USBDrive
order no date Salesman region product units amount
1 5/1/2014 Vishal North Mobile 5 50000
2 5/2/2014 Amit East TV 10 250000
3 5/3/2014 Mihir West Laptop 15 600000
4 5/4/2014 Kiran South HDD 5 15000
5 5/5/2014 Rohit North USBDrive 10 8000
6 5/6/2014 Bharat East Mobile 10 200000
7 5/7/2014 Vishal West TV 10 250000
8 5/8/2014 Amit South Laptop 15 600000
9 5/9/2014 Mihir North HDD 10 30000
10 5/10/2014 Kiran East USBDrive 5 4000
11 6/1/2014 Rohit West Mobile 15 150000
12 6/2/2014 Bharat South TV 15 375000
13 6/3/2014 Vishal North Laptop 10 400000
14 6/4/2014 Amit East HDD 20 60000
15 6/5/2014 Mihir West USBDrive 5 4000
16 6/6/2014 Kiran South Mobile 15 150000
17 6/7/2014 Rohit North TV 15 375000
18 6/8/2014 Bharat East Laptop 10 400000
19 6/9/2014 Vishal West HDD 15 45000
20 6/10/2014 Amit South USBDrive 15 12000
21 7/2/2014 Mihir North Mobile 20 200000
22 7/3/2014 Kiran East TV 5 125000
23 7/4/2014 Rohit West Laptop 10 400000
24 7/5/2014 Bharat South HDD 10 30000
25 7/6/2014 Vishal North USBDrive 15 12000
26 7/7/2014 Amit East Mobile 20 200000
27 7/8/2014 Mihir West TV 20 500000
28 7/9/2014 Kiran South Laptop 20 800000
29 7/10/2014 Rohit North HDD 20 60000
30 7/11/2014 Bharat East USBDrive 15 12000
31 8/2/2014 Vishal West Mobile 10 100000
32 8/3/2014 Amit South TV 5 125000
33 8/4/2014 Mihir North Laptop 10 400000
34 8/5/2014 Kiran East HDD 20 60000
35 8/6/2014 Rohit West USBDrive 5 4000
36 8/7/2014 Bharat South Mobile 20 200000
37 8/8/2014 Vishal North TV 10 250000
38 8/9/2014 Amit East Laptop 5 200000
39 8/10/2014 Mihir West HDD 5 15000
40 8/11/2014 Kiran South USBDrive 5 4000
41 9/2/2014 Rohit North Mobile 15 150000
42 9/3/2014 Bharat East TV 10 250000
43 9/4/2014 Vishal West Laptop 10 400000
44 9/5/2014 Amit South HDD 20 60000
45 9/6/2014 Mihir North USBDrive 5 4000
46 9/7/2014 Kiran East Mobile 15 150000
47 9/8/2014 Rohit West TV 10 250000
48 9/9/2014 Bharat South Laptop 20 800000
49 9/10/2014 Vishal North HDD 15 45000
50 9/11/2014 Amit East USBDrive 15 12000
51 10/3/2014 Mihir West Mobile 15 150000
52 10/4/2014 Kiran South TV 10 250000
53 10/5/2014 Rohit North Laptop 10 400000
54 10/6/2014 Bharat East HDD 15 45000
55 10/7/2014 Vishal West USBDrive 10 8000
56 10/8/2014 Amit South Mobile 15 150000
57 10/9/2014 Mihir North TV 15 375000
58 10/10/2014 Kiran East Laptop 15 600000
59 10/11/2014 Rohit West HDD 10 30000
60 10/12/2014 Bharat South USBDrive 10 8000
61 11/3/2014 Vishal North Mobile 15 150000
62 11/4/2014 Amit East TV 10 250000
63 11/5/2014 Mihir West Laptop 20 800000
64 11/6/2014 Kiran South HDD 15 45000
65 11/7/2014 Rohit North USBDrive 10 8000
66 11/8/2014 Bharat East Mobile 5 50000
67 11/9/2014 Vishal West TV 20 500000
68 11/10/2014 Amit South Laptop 20 800000
69 11/11/2014 Mihir North HDD 20 60000
70 11/12/2014 Kiran East USBDrive 15 12000
71 12/4/2014 Rohit West Mobile 15 150000
72 12/5/2014 Bharat South TV 15 375000
73 12/6/2014 Vishal North Laptop 10 400000
74 12/7/2014 Amit East HDD 15 45000
75 12/8/2014 Mihir West USBDrive 15 12000
76 12/9/2014 Kiran South Mobile 20 200000
77 12/10/2014 Rohit North TV 10 250000
78 12/11/2014 Bharat East Laptop 5 200000
79 12/12/2014 Vishal West HDD 20 60000
80 12/13/2014 Amit South USBDrive 10 8000
81 1/4/2015 Mihir North Mobile 5 50000
82 1/5/2015 Kiran East TV 15 375000
83 1/6/2015 Rohit West Laptop 10 400000
84 1/7/2015 Bharat South HDD 10 30000
85 1/8/2015 Vishal North USBDrive 15 12000
86 1/9/2015 Amit East Mobile 10 100000
87 1/10/2015 Mihir West TV 15 375000
88 1/11/2015 Kiran South Laptop 20 800000
89 1/12/2015 Rohit North HDD 15 45000
90 1/13/2015 Bharat East USBDrive 5 4000
91 2/4/2015 Vishal West Mobile 15 150000
92 2/5/2015 Amit South TV 10 250000
93 2/6/2015 Mihir North Laptop 20 800000
94 2/7/2015 Kiran East HDD 5 15000
95 2/8/2015 Rohit West USBDrive 5 4000
96 2/9/2015 Bharat South Mobile 10 100000
97 2/10/2015 Vishal North TV 15 375000
98 2/11/2015 Amit East Laptop 10 400000
99 2/12/2015 Mihir West HDD 15 45000
100 2/13/2015 Kiran South USBDrive 10 8000
