Row Labels Sum of Total Sales Sum of Total Sales

Bakery 5382
Beverages 4926
Dairy 8795
Fruits 6084 10000
Snacks 7668 9000
8000
Vegetables 8919 7000
Grand Total 41775 6000
5000
4000
3000
2000
1000
0
Bakery Beverages Dairy Fruits
Product Category
 Total

Fruits Snacks Vegetables

Row Labels Sum of Total Sales
Sum of Total Sales
Member 21806
22000
Visitor 19969
Grand Total 41775 21500

21000

20500

20000

19500

19000
Member

Customer Type
 Total

Visitor
Row Labels Average of Unit Price Average of Unit Price
Bakery 30
31
Beverages 27
Dairy 28 30
Fruits 31
29
Snacks 28
Vegetables 29 28
Grand Total 29 27

26

25
Bakery Beverages Dairy

Product Category
 Total

Dairy Fruits Snacks Vegetables

Row Labels Sum of Quantity Sum of Quantity
Bakery 138 200
Beverages 105 180
Dairy 178 160
Fruits 129 140
Snacks 115 120
Vegetables 171 100
Grand Total 836 80
60
40
20
0
Bakery Beverages Dairy Fruits

Product Category
 Total

Fruits Snacks Vegetables

Sum of Total Sales Column Labels
Sum of Total Sales
Row Labels Female Male Grand Total
6000
Bakery 2522 2860 5382
Beverages 1925 3001 4926 5000
Dairy 4611 4184 8795
4000
Fruits 2732 3352 6084
Snacks 5463 2205 7668 3000
Vegetables 4533 4386 8919
2000
Grand Total 21785 19990 41775
1000

0
Bakery Beverages Dairy

Product Category
 Gender
Female
Male

Dairy Fruits Snacks Vegetables

 CUS
Sum of Total Sales Sum of Total Sales
10000 22000
8000 21500
6000 21000
4000 20500
Total
2000
20000
0
19500

19000
Member

Product Category Customer Type

Sum of Quantity
200

150

100

50

0
Bakery Beverages Dairy Fruits Snacks Vegetables

Product Category
 CUSTOMER PURCHASE DATABASE
Average of Unit Price
31
30
29
28
27
Total
26
25

Member Visitor

Product Category

Sum of Total Sales

6000
5000
4000
Gender
3000
Total Female
2000
Male
1000
0
Vegetables Bakery Beverages Dairy Fruits Snacks Vegetables

Product Category
ATABASE
Product Category

Bakery
Beverages
Gender
Dairy
Total Fruits Female

Quantity Male

1
2
3
4
5 Customer Type

Member
Unit Price Visitor

5.28
5.35
6.12
6.24
r Type

r
Invoice ID Date Customer Type Gender Product Category Unit Price
INV0001 3/10/2024 Member Male Snacks 24.72
INV0002 3/4/2024 Visitor Female Vegetables 44.27
INV0003 3/11/2024 Visitor Female Fruits 27.93
INV0004 3/7/2024 Visitor Female Fruits 39.68
INV0005 3/17/2024 Visitor Male Vegetables 38.59
INV0006 3/16/2024 Member Male Dairy 19.63
INV0007 3/29/2024 Member Male Bakery 17.04
INV0008 3/20/2024 Member Male Vegetables 31.17
INV0009 3/26/2024 Visitor Female Fruits 20.92
INV0010 3/6/2024 Visitor Male Beverages 39.58
INV0011 3/7/2024 Visitor Female Dairy 43.98
INV0012 3/27/2024 Visitor Female Dairy 35.49
INV0013 3/27/2024 Visitor Male Dairy 21.48
INV0014 3/25/2024 Member Female Vegetables 6.24
INV0015 3/21/2024 Member Male Fruits 29.38
INV0016 3/19/2024 Member Female Vegetables 21.14
INV0017 3/2/2024 Member Female Snacks 22.58
INV0018 3/29/2024 Visitor Male Dairy 46.27
INV0019 3/27/2024 Member Male Vegetables 23.8
INV0020 3/17/2024 Member Female Snacks 24.81
INV0021 3/3/2024 Visitor Female Dairy 48.38
INV0022 3/23/2024 Visitor Male Beverages 23.57
INV0023 3/28/2024 Visitor Male Dairy 23.71
INV0024 3/11/2024 Member Male Dairy 27.12
INV0025 3/11/2024 Member Male Beverages 10.22
INV0026 3/7/2024 Visitor Female Beverages 36.65
INV0027 3/30/2024 Member Female Fruits 32.45
INV0028 3/1/2024 Visitor Male Dairy 15.12
INV0029 3/8/2024 Member Female Bakery 26.11
INV0030 3/29/2024 Member Male Bakery 27.57
INV0031 3/26/2024 Member Male Bakery 44.78
INV0032 3/23/2024 Member Male Vegetables 24.99
INV0033 3/7/2024 Visitor Male Bakery 27.08
INV0034 3/27/2024 Visitor Female Dairy 19.5
INV0035 3/1/2024 Member Male Fruits 37.04
INV0036 3/30/2024 Member Female Vegetables 5.35
INV0037 3/8/2024 Visitor Male Fruits 10.98
INV0038 3/9/2024 Member Male Fruits 18.87
INV0039 3/9/2024 Member Female Vegetables 11.88
INV0040 3/4/2024 Member Male Fruits 34.25
INV0041 3/19/2024 Visitor Male Vegetables 15.02
INV0042 3/1/2024 Visitor Female Vegetables 44.62
INV0043 3/21/2024 Member Male Snacks 33.42
INV0044 3/1/2024 Member Female Dairy 21.67
INV0045 3/19/2024 Member Male Snacks 34.82
INV0046 3/5/2024 Visitor Female Beverages 42.07
INV0047 3/30/2024 Visitor Male Beverages 14.89
INV0048 3/17/2024 Member Male Vegetables 20.06
INV0049 3/21/2024 Visitor Female Fruits 44.3
INV0050 3/13/2024 Visitor Female Dairy 34.16
INV0051 3/4/2024 Member Male Beverages 12.49
INV0052 3/15/2024 Member Female Vegetables 35.83
INV0053 3/13/2024 Member Male Fruits 31.49
INV0054 3/20/2024 Member Female Dairy 34.81
INV0055 3/8/2024 Member Male Beverages 37.54
INV0056 3/11/2024 Visitor Female Beverages 36.85
INV0057 3/6/2024 Member Female Bakery 29.25
INV0058 3/24/2024 Member Female Beverages 18.5
INV0059 3/15/2024 Visitor Male Snacks 38.3
INV0060 3/29/2024 Visitor Female Snacks 49.83
INV0061 3/1/2024 Visitor Male Dairy 33.04
INV0062 3/16/2024 Member Male Fruits 34
INV0063 3/30/2024 Visitor Male Fruits 45.85
INV0064 3/24/2024 Visitor Male Dairy 6.75
INV0065 3/9/2024 Member Male Fruits 23.83
INV0066 3/11/2024 Visitor Male Vegetables 45.07
INV0067 3/4/2024 Member Female Bakery 14.22
INV0068 3/2/2024 Member Male Vegetables 17.32
INV0069 3/3/2024 Member Female Bakery 6.12
INV0070 3/5/2024 Member Female Vegetables 43.64
INV0071 3/24/2024 Visitor Male Dairy 6.93
INV0072 3/25/2024 Visitor Female Vegetables 45.8
INV0073 3/1/2024 Visitor Female Snacks 45.61
INV0074 3/9/2024 Member Female Vegetables 19.3
INV0075 3/23/2024 Member Male Bakery 14.6
INV0076 3/2/2024 Visitor Male Bakery 16.99
INV0077 3/6/2024 Visitor Male Snacks 7.6
INV0078 3/9/2024 Visitor Female Beverages 10.29
INV0079 3/7/2024 Visitor Male Vegetables 26.53
INV0080 3/27/2024 Member Male Snacks 36.17
INV0081 3/21/2024 Visitor Female Dairy 15.74
INV0082 3/13/2024 Member Female Vegetables 13.68
INV0083 3/8/2024 Visitor Female Snacks 7.01
INV0084 3/23/2024 Visitor Male Dairy 24.36
INV0085 3/16/2024 Visitor Male Vegetables 34.81
INV0086 3/10/2024 Member Male Vegetables 23.45
INV0087 3/29/2024 Member Male Dairy 25.14
INV0088 3/17/2024 Visitor Female Vegetables 32.51
INV0089 3/30/2024 Member Female Dairy 46
INV0090 3/25/2024 Visitor Female Dairy 38.4
INV0091 3/6/2024 Member Female Bakery 37.81
INV0092 3/25/2024 Visitor Female Dairy 13.96
INV0093 3/25/2024 Visitor Female Snacks 13.14
INV0094 3/12/2024 Visitor Female Snacks 13.22
INV0095 3/27/2024 Visitor Female Dairy 5.28
INV0096 3/20/2024 Visitor Male Vegetables 39.87
INV0097 3/29/2024 Member Female Snacks 38.91
INV0098 3/13/2024 Member Female Fruits 43.13
INV0099 3/24/2024 Visitor Female Snacks 6.64
INV0100 3/20/2024 Visitor Male Bakery 42.56
INV0101 3/7/2024 Member Male Fruits 42.36
INV0102 3/20/2024 Member Male Vegetables 47
INV0103 3/16/2024 Visitor Male Snacks 33.89
INV0104 3/30/2024 Member Male Bakery 20.74
INV0105 3/4/2024 Visitor Female Fruits 34.06
INV0106 3/11/2024 Member Male Beverages 42.04
INV0107 3/24/2024 Member Female Beverages 28.48
INV0108 3/7/2024 Visitor Male Vegetables 25.21
INV0109 3/10/2024 Member Male Bakery 46.55
INV0110 3/11/2024 Visitor Male Fruits 16.83
INV0111 3/15/2024 Member Female Fruits 9.85
INV0112 3/21/2024 Member Female Snacks 18.44
INV0113 3/31/2024 Visitor Male Beverages 15.97
INV0114 3/5/2024 Member Male Vegetables 23.28
INV0115 3/31/2024 Visitor Female Snacks 23.43
INV0116 3/1/2024 Member Male Beverages 47.49
INV0117 3/15/2024 Visitor Female Snacks 9.05
INV0118 3/1/2024 Member Female Beverages 49.6
INV0119 3/24/2024 Member Female Bakery 38.66
INV0120 3/22/2024 Visitor Male Dairy 40.55
INV0121 3/16/2024 Member Male Vegetables 32.64
INV0122 3/30/2024 Member Female Fruits 21.5
INV0123 3/24/2024 Visitor Male Vegetables 45.64
INV0124 3/25/2024 Visitor Female Vegetables 24.56
INV0125 3/7/2024 Visitor Male Fruits 41.6
INV0126 3/21/2024 Member Female Fruits 34.25
INV0127 3/6/2024 Visitor Male Bakery 44.83
INV0128 3/2/2024 Member Female Bakery 30.8
INV0129 3/1/2024 Member Female Bakery 15.7
INV0130 3/3/2024 Member Male Dairy 46.52
INV0131 3/6/2024 Visitor Female Vegetables 33.69
INV0132 3/1/2024 Member Male Dairy 20.21
INV0133 3/28/2024 Visitor Male Dairy 47.19
INV0134 3/27/2024 Member Female Snacks 22.4
INV0135 3/20/2024 Member Male Dairy 19.23
INV0136 3/11/2024 Member Female Snacks 41.18
INV0137 3/23/2024 Member Female Snacks 41.32
INV0138 3/20/2024 Visitor Male Fruits 27.24
INV0139 3/30/2024 Member Male Beverages 14.33
INV0140 3/11/2024 Member Male Snacks 35.55
INV0141 3/10/2024 Visitor Male Dairy 45.75
INV0142 3/14/2024 Visitor Female Dairy 30.08
INV0143 3/16/2024 Visitor Female Snacks 30.93
INV0144 3/5/2024 Visitor Female Dairy 28.37
INV0145 3/30/2024 Member Female Snacks 42.44
INV0146 3/2/2024 Member Female Bakery 39.94
INV0147 3/23/2024 Visitor Female Beverages 8.85
INV0148 3/2/2024 Member Female Dairy 13.95
INV0149 3/22/2024 Member Female Bakery 47.53
INV0150 3/1/2024 Visitor Female Bakery 42.2
Quantity Total Sales Payment Method
3 323.78 Cash
7 354.98 Credit Card
8 45.14 Credit Card
1 52.96 Mobile Payment
10 95.29 Cash
5 175.06 Credit Card
7 148.59 Cash
9 200.59 Mobile Payment
1 369.87 Cash
4 390.63 Mobile Payment
6 40.33 Credit Card
4 382.66 Cash
4 100.92 Credit Card
4 448.64 Cash
8 273.86 Credit Card
6 458.27 Mobile Payment
3 287.88 Cash
4 464.71 Cash
7 318.61 Mobile Payment
6 57.77 Mobile Payment
1 321.09 Cash
8 314.15 Cash
9 320.81 Mobile Payment
9 327.7 Cash
4 402.83 Credit Card
8 277.19 Mobile Payment
10 266.22 Cash
5 222.73 Cash
10 315.96 Mobile Payment
8 437.87 Mobile Payment
7 467.79 Mobile Payment
1 302.16 Credit Card
10 59.55 Mobile Payment
3 445.16 Mobile Payment
8 161.09 Cash
7 305.37 Mobile Payment
6 494.68 Cash
8 60.46 Cash
5 260.59 Credit Card
3 213.72 Credit Card
3 345.13 Cash
7 467.76 Credit Card
2 357.84 Cash
9 78.97 Cash
4 351.1 Credit Card
2 213.68 Credit Card
9 183.58 Mobile Payment
7 231.3 Cash
3 185.18 Credit Card
1 416.9 Credit Card
7 419.92 Cash
8 262.23 Mobile Payment
7 434.59 Cash
3 430.35 Cash
4 388.57 Credit Card
5 221.12 Credit Card
9 196.68 Cash
4 357.65 Cash
3 206.32 Credit Card
4 283.78 Cash
2 423.82 Mobile Payment
1 334.35 Credit Card
6 499.62 Cash
5 337.56 Credit Card
6 189.37 Credit Card
7 67.75 Cash
3 68.19 Mobile Payment
1 226.31 Mobile Payment
10 277.62 Mobile Payment
1 445.83 Mobile Payment
10 25.95 Credit Card
7 169.88 Credit Card
2 335.05 Credit Card
8 89.25 Mobile Payment
2 373.03 Cash
8 233.63 Credit Card
3 417.37 Cash
5 396.23 Cash
4 167.21 Credit Card
6 96.17 Credit Card
9 494.13 Credit Card
4 405.38 Cash
8 369.7 Credit Card
9 262.49 Credit Card
2 456.66 Mobile Payment
7 246.71 Credit Card
7 116.82 Mobile Payment
5 493.8 Credit Card
9 88.65 Cash
4 365.49 Cash
3 176.6 Mobile Payment
10 374.84 Credit Card
4 407.11 Mobile Payment
8 483.88 Cash
3 330.93 Mobile Payment
7 263.98 Cash
3 302.56 Cash
5 484.24 Mobile Payment
1 264.13 Cash
2 362.04 Cash
8 84.79 Cash
8 423.83 Cash
3 106.82 Mobile Payment
9 143.03 Credit Card
1 186.17 Mobile Payment
7 126.77 Mobile Payment
7 127.52 Mobile Payment
5 64.22 Cash
7 461.52 Credit Card
2 331.54 Mobile Payment
10 441.25 Mobile Payment
9 434.02 Mobile Payment
3 300.48 Credit Card
2 437.49 Mobile Payment
9 474.21 Cash
4 128.36 Cash
8 302.67 Mobile Payment
6 42.85 Mobile Payment
7 457.84 Mobile Payment
5 492.67 Mobile Payment
4 181.59 Cash
8 246.73 Credit Card
5 357.22 Credit Card
7 308.23 Mobile Payment
10 58.49 Cash
7 454.06 Mobile Payment
9 173.13 Cash
10 155.4 Credit Card
6 362.18 Credit Card
2 463.9 Credit Card
6 62.66 Credit Card
1 134.36 Credit Card
2 33.38 Cash
2 409.19 Mobile Payment
4 101.18 Mobile Payment
4 230.26 Cash
7 386.18 Cash
2 215.93 Cash
8 346.06 Credit Card
6 345.85 Credit Card
9 180.21 Mobile Payment
9 294.91 Credit Card
1 240.47 Mobile Payment
5 157.76 Mobile Payment
6 194.11 Cash
1 40.3 Credit Card
10 288.78 Cash
10 388.5 Mobile Payment
8 412.13 Cash
2 59.04 Mobile Payment