Forum Questions.xlsx

	C	D	E	F	G	H	I	J	K
1
2
3	Period	CustRegion	CustLocationDesc	customercode	account_name	OA	QtyDus	Amt
4	7	R5-3	KLUNGKUNG	GI0210	PT. GI	1,817	18,740.00	63,168,244
5	8	R5-3	KLUNGKUNG	GI0210	PT. GI	2,070	29,077.58	12,872,632
6	9	R5-3	KLUNGKUNG	GI0210	PT. GI	2,313	49,687.00	11,500,113
7	10	R5-3	KLUNGKUNG	GI0210	PT. GI	2,531	55,121.63	39,848,120
8	11	R5-3	KLUNGKUNG	GI0210	PT. GI	3,881	41,955.00	35,654,224
9	12	R5-3	KLUNGKUNG	GI0210	PT. GI	3,025	43,076.28	52,706,016
10	7	R5-3	DENPASAR	RC0219	CV. RC	2,711	46,991.14	33,808,395
11	8	R5-3	DENPASAR	RC0219	CV. RC	2,467	76,804.77	54,941,923
12	9	R5-3	DENPASAR	RC0219	CV. RC	2,212	79,573.18	16,839,081
13	10	R5-3	DENPASAR	RC0219	CV. RC	2,518	91,878.29	86,223,798
14	11	R5-3	DENPASAR	RC0219	CV. RC	2,258	78,113.86	64,815,022
15	12	R5-3	DENPASAR	RC0219	CV. RC	3,380	68,769.17	61,277,239
16	7	R7-0	BANJARMASIN	LI0288	PT. LIJ	1,615	5,620.43	8,775,921
17	8	R7-0	BANJARMASIN	LI0288	PT. LIJ	2,155	12,386.43	23,722,281
18	9	R7-0	BANJARMASIN	LI0288	PT. LIJ	2,919	17,744.96	78,969,659
19	10	R7-0	BANJARMASIN	LI0288	PT. LIJ	2,866	26,165.18	15,607,616
20	11	R7-0	BANJARMASIN	LI0288	PT. LIJ	2,991	40,459.17	98,541,003
21	12	R7-0	BANJARMASIN	LI0288	PT. LIJ	3,558	16,154.11	11,816,625
22
23
24
25
26
27		slicers			Parameter
28		Month	10 until 12		OA	>= 2,500		QtyDus	>=40,000
29
30
31
32
33
34
35		The result expected, excluding the strikethrough
36
37		CustRegion	CustLocationDesc	customercode	account_name	Avg_OA	Avg_QtyDus	Avg_Amt
38		R5-3	KLUNGKUNG	GI0210	PT. GI	3,145.67	46,717.64	42,736,120
39		R5-3	DENPASAR	RC0219	CV. RC	2,719	79,587.11	70,772,020
40		R7-0	BANJARMASIN	LI0288	PT. LIJ	3,138	27,592.82	41,988,415
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100