Order ID Customer Name Product Category Quantity Price per Unit Discount (%)

1001 Alice Johnson Laptop Electronics 9 1877 5

1002 Alice Johnson Smartphone Accessories 8 1663 10
1003 Bob Brown Laptop Electronics 7 1351 19
1004 Charlie Wilson Tablet Electronics 3 794 9
1005 Charlie Wilson Monitor Accessories 9 517 22
1006 Bob Brown Monitor Accessories 1 775 3
1007 John Doe Monitor Accessories 7 1456 17
1008 Alice Johnson Laptop Electronics 4 497 16
1009 Charlie Wilson Laptop Accessories 5 170 2
1010 Charlie Wilson Monitor Accessories 2 1919 18
1011 Jane Smith Monitor Electronics 1 119 4
1012 Bob Brown Tablet Accessories 9 744 2
1013 Alice Johnson Smartphone Electronics 8 923 21
1014 John Doe Keyboard Accessories 5 1806 9
1015 Charlie Wilson Tablet Electronics 9 780 23
1016 Alice Johnson Keyboard Electronics 7 248 19
1017 Jane Smith Laptop Electronics 3 116 14
1018 Charlie Wilson Keyboard Electronics 8 828 11
1019 Charlie Wilson Smartphone Accessories 1 545 12
1020 Jane Smith Tablet Accessories 5 734 5
1021 Bob Brown Laptop Electronics 4 860 2
1022 John Doe Monitor Accessories 8 1550 3
1023 Jane Smith Monitor Electronics 8 236 12
1024 Jane Smith Tablet Electronics 3 839 5
1025 Jane Smith Smartphone Electronics 9 566 5
1026 John Doe Monitor Accessories 2 1818 11
1027 Charlie Wilson Laptop Electronics 5 580 16
1028 Jane Smith Tablet Accessories 7 365 23
1029 Bob Brown Smartphone Electronics 4 1299 23
1030 Bob Brown Laptop Accessories 7 217 10
1031 Charlie Wilson Tablet Electronics 3 414 9
1032 Charlie Wilson Laptop Electronics 3 1567 11
1033 Alice Johnson Laptop Accessories 6 1083 3
1034 Alice Johnson Smartphone Accessories 6 1442 6
1035 Charlie Wilson Tablet Electronics 6 1421 11
1036 Charlie Wilson Tablet Electronics 9 1366 13
1037 Alice Johnson Keyboard Accessories 3 1243 4
1038 Bob Brown Laptop Electronics 2 459 4
1039 Alice Johnson Tablet Accessories 1 1630 7
1040 Alice Johnson Keyboard Electronics 3 1191 24
1041 Bob Brown Laptop Accessories 4 480 2
1042 John Doe Smartphone Electronics 7 1601 23
1043 Charlie Wilson Smartphone Accessories 7 132 6
1044 Bob Brown Smartphone Accessories 6 707 7
1045 Bob Brown Keyboard Accessories 8 872 3
1046 John Doe Tablet Accessories 9 1774 10
1047 Bob Brown Tablet Electronics 5 1699 23
1048 Charlie Wilson Laptop Electronics 3 1650 9
1049 Jane Smith Laptop Electronics 1 176 5
1050 Charlie Wilson Laptop Accessories 3 737 9
 Order Date Region Sales Rep
Payment Method Helper Column Total Sales
2024-01-01 00:00:00 West Rep B Bank TransLaptopWest 16048.35
2024-01-02 00:00:00 West Rep B Credit CardSmartphoneWest 11973.6
2024-01-03 00:00:00 South Rep A PayPal LaptopSouth 7660.17
2024-01-04 00:00:00 East Rep A Bank TransTabletEast 2167.62
2024-01-05 00:00:00 West Rep A Bank TransMonitorWest 3629.34
2024-01-06 00:00:00 West Rep B Credit CardMonitorWest 751.75
2024-01-07 00:00:00 West Rep C Credit CardMonitorWest 8459.36
2024-01-08 00:00:00 South Rep C PayPal LaptopSouth 1669.92
2024-01-09 00:00:00 South Rep C Credit CardLaptopSouth 833
2024-01-10 00:00:00 North Rep A Bank TransMonitorNorth 3147.16
2024-01-11 00:00:00 North Rep B PayPal MonitorNorth 114.24
2024-01-12 00:00:00 East Rep C PayPal TabletEast 6562.08
2024-01-13 00:00:00 West Rep C Bank TransSmartphoneWest 5833.36
2024-01-14 00:00:00 East Rep A PayPal KeyboardEast 8217.3
2024-01-15 00:00:00 East Rep C Bank TransTabletEast 5405.4
2024-01-16 00:00:00 West Rep A PayPal KeyboardWest 1406.16
2024-01-17 00:00:00 East Rep C Credit CardLaptopEast 299.28
2024-01-18 00:00:00 North Rep A PayPal KeyboardNorth 5895.36
2024-01-19 00:00:00 West Rep A Bank TransSmartphoneWest 479.6
2024-01-20 00:00:00 East Rep A Bank TransTabletEast 3486.5
2024-01-21 00:00:00 South Rep A Bank TransLaptopSouth 3371.2
2024-01-22 00:00:00 South Rep C PayPal MonitorSouth 12028
2024-01-23 00:00:00 North Rep C PayPal MonitorNorth 1661.44
2024-01-24 00:00:00 North Rep C Bank TransTabletNorth 2391.15
2024-01-25 00:00:00 South Rep B Credit CardSmartphoneSouth 4839.3
2024-01-26 00:00:00 East Rep A PayPal MonitorEast 3236.04
2024-01-27 00:00:00 West Rep A Credit CardLaptopWest 2436
2024-01-28 00:00:00 South Rep C Credit CardTabletSouth 1967.35
2024-01-29 00:00:00 South Rep C Credit CardSmartphoneSouth 4000.92
2024-01-30 00:00:00 East Rep C Bank TransLaptopEast 1367.1
2024-01-31 00:00:00 South Rep B Bank TransTabletSouth 1130.22
2024-02-01 00:00:00 North Rep C Bank TransLaptopNorth 4183.89
2024-02-02 00:00:00 South Rep A Credit CardLaptopSouth 6303.06
2024-02-03 00:00:00 East Rep B Credit CardSmartphoneEast 8132.88
2024-02-04 00:00:00 East Rep A Bank TransTabletEast 7588.14
2024-02-05 00:00:00 North Rep A Credit CardTabletNorth 10695.78
2024-02-06 00:00:00 North Rep B Bank TransKeyboardNorth 3579.84
2024-02-07 00:00:00 West Rep C PayPal LaptopWest 881.28
2024-02-08 00:00:00 West Rep A Bank TransTabletWest 1515.9
2024-02-09 00:00:00 West Rep C PayPal KeyboardWest 2715.48
2024-02-10 00:00:00 West Rep A PayPal LaptopWest 1881.6
2024-02-11 00:00:00 South Rep A Bank TransSmartphoneSouth 8629.39
2024-02-12 00:00:00 North Rep B PayPal SmartphoneNorth 868.56
2024-02-13 00:00:00 East Rep C PayPal SmartphoneEast 3945.06
2024-02-14 00:00:00 South Rep A Credit CardKeyboardSouth 6766.72
2024-02-15 00:00:00 South Rep A Bank TransTabletSouth 14369.4
2024-02-16 00:00:00 South Rep C Credit CardTabletSouth 6541.15
2024-02-17 00:00:00 South Rep A Credit CardLaptopSouth 4504.5
2024-02-18 00:00:00 West Rep A Bank TransLaptopWest 167.2
2024-02-19 00:00:00 North Rep A PayPal LaptopNorth 2012.01
14)
4183.89

8)
12
9)
22
11)
2
6) 7)
Product Sum of Price per Unit Product Average of Total Sales
Smartphone 8878 Keyboard Total
###
Total Result 8878 Laptop ###
Monitor ###
Smartphone ###
2024-01-28 2024-01-27 2024-01-28
Tablet
08:00:00 2024-01-27 ###
03:12:00 21:20:00 02:00:00 2024-01-25
Total Result ### 12:00:00
Average of Total Sales

2024-01-13
18:00:00

Keyboard Laptop Monitor Smartphone Tablet Total Result

13)
Product Tablet
Quantity - multiple -
15)
Sum of Total Sales
###
Total
Sum of Total Sales
12
###
10

0
2265601
 10)
Payment Method
5
Average of Total Sales
Sum of Total Sales
###
12)
Discount (%) - multiple -
Sales Rep - all -

Average of Total Sales

lt
2024-01-22 13:05:27

Total

Column F

2265601
- all -