Power Query Question.xlsx

	B	C	D	E	G	H	I	J	K	L	M	N
1
2
3
4	A	B	C	annual			A	Values
5	Scen1	apple	apple1	1			Scen1		Scen2		Scen3
6	Scen1	apple	apple1	2	B	C	Sum of annual	Sum of annual2	Sum of annual	Sum of annual2	Sum of annual	Sum of annual2
7	Scen1	apple	apple2	3	pineapple	pineapple3	10	10	106	106	6	6
8	Scen1	apple	apple2	4		pineapple1	43	43
9	Scen2	apple	apple1	5		pineapple2			37	37
10	Scen2	apple	apple2	5		pineapple4	4	4
11	Scen2	apple	apple3	3	pineapple Total		57	57	143	143	6	6
12	Scen2	apple	apple3	4	apple	apple2	7	7	5	5	5	5
13	Scen3	apple	apple2	5		apple1	3	3	5	5	6	6
14	Scen3	apple	apple1	6		apple3			7	7
15	Scen1	banana	banana1	1	apple Total		10	10	17	17	11	11
16	Scen1	banana	banana2	2	banana	banana3					11	11
17	Scen1	banana	banana2	3		banana2	9	9
18	Scen1	banana	banana2	4		banana1	1	1
19	Scen3	banana	banana3	5	banana Total		10	10			11	11
20	Scen3	banana	banana3	6	Grand Total		77	77	160	160	28	28
21	Scen1	pineapple	pineapple4	4
22	Scen1	pineapple	pineapple1	43
23	Scen1	pineapple	pineapple3	2
24	Scen1	pineapple	pineapple3	8
25	Scen2	pineapple	pineapple3	9
26	Scen2	pineapple	pineapple3	97
27	Scen2	pineapple	pineapple2	4
28	Scen2	pineapple	pineapple2	33
29	Scen3	pineapple	pineapple3	3
30	Scen3	pineapple	pineapple3	3
31
32
33
34
35
36
37
38
39
40
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