Spreadsheet: 94637d1294399081-using-the-same-pivot-tables-for-different-data-query
Sheet: contribution

Percentage |  |  |  |  |  | Actual data
weeks | A | B | C | D |  | weeks | Sum | A | B | C | D
1 |  |  |  |  |  | 1 |  | 1152 | 152 | 103 | 564
2 |  |  |  |  |  | 2 |  | GETPIVOTDATA fn | GETPIVOTDATA fn | GETPIVOTDATA fn | GETPIVOTDATA fn
3 |  |  |  |  |  | 3 |  | GETPIVOTDATA fn | GETPIVOTDATA fn | GETPIVOTDATA fn | GETPIVOTDATA fn
4 |  |  |  |  |  | 4 |  | GETPIVOTDATA fn | GETPIVOTDATA fn | GETPIVOTDATA fn | GETPIVOTDATA fn
5 |  |  |  |  |  | 5 |  | GETPIVOTDATA fn | GETPIVOTDATA fn | GETPIVOTDATA fn | GETPIVOTDATA fn
6 |  |  |  |  |  | 6 |  | GETPIVOTDATA fn | GETPIVOTDATA fn | GETPIVOTDATA fn | GETPIVOTDATA fn
7 |  |  |  |  |  | 7 |  | GETPIVOTDATA fn | GETPIVOTDATA fn | GETPIVOTDATA fn | GETPIVOTDATA fn
8 |  |  |  |  |  | 8 |  | GETPIVOTDATA fn | GETPIVOTDATA fn | GETPIVOTDATA fn | GETPIVOTDATA fn
9 |  |  |  |  |  | 9 |  | GETPIVOTDATA fn | GETPIVOTDATA fn | GETPIVOTDATA fn | GETPIVOTDATA fn
10 |  |  |  |  |  | 10 |  | GETPIVOTDATA fn | GETPIVOTDATA fn | GETPIVOTDATA fn | GETPIVOTDATA fn
11 |  |  |  |  |  | 11 |  | GETPIVOTDATA fn | GETPIVOTDATA fn | GETPIVOTDATA fn | GETPIVOTDATA fn
12 |  |  |  |  |  | 12 |  | GETPIVOTDATA fn | GETPIVOTDATA fn | GETPIVOTDATA fn | GETPIVOTDATA fn
13 |  |  |  |  |  | 13 |  | GETPIVOTDATA fn | GETPIVOTDATA fn | GETPIVOTDATA fn | GETPIVOTDATA fn
14 |  |  |  |  |  | 14 |  | GETPIVOTDATA fn | GETPIVOTDATA fn | GETPIVOTDATA fn | GETPIVOTDATA fn
15 |  |  |  |  |  | 15 |  | GETPIVOTDATA fn | GETPIVOTDATA fn | GETPIVOTDATA fn | GETPIVOTDATA fn
16 |  |  |  |  |  | 16 |  | GETPIVOTDATA fn | GETPIVOTDATA fn | GETPIVOTDATA fn | GETPIVOTDATA fn
17 |  |  |  |  |  | 17 |  | GETPIVOTDATA fn | GETPIVOTDATA fn | GETPIVOTDATA fn | GETPIVOTDATA fn
18 |  |  |  |  |  | 18 |  | GETPIVOTDATA fn | GETPIVOTDATA fn | GETPIVOTDATA fn | GETPIVOTDATA fn
19 |  |  |  |  |  | 19 |  | GETPIVOTDATA fn | GETPIVOTDATA fn | GETPIVOTDATA fn | GETPIVOTDATA fn
20 |  |  |  |  |  | 20 |  | GETPIVOTDATA fn | GETPIVOTDATA fn | GETPIVOTDATA fn | GETPIVOTDATA fn
21 |  |  |  |  |  | 21 |  | GETPIVOTDATA fn | GETPIVOTDATA fn | GETPIVOTDATA fn | GETPIVOTDATA fn
22 |  |  |  |  |  | 22 |  | GETPIVOTDATA fn | GETPIVOTDATA fn | GETPIVOTDATA fn | GETPIVOTDATA fn
23 |  |  |  |  |  | 23 |  | GETPIVOTDATA fn | GETPIVOTDATA fn | GETPIVOTDATA fn | GETPIVOTDATA fn
24 |  |  |  |  |  | 24 |  | GETPIVOTDATA fn | GETPIVOTDATA fn | GETPIVOTDATA fn | GETPIVOTDATA fn
25 |  |  |  |  |  | 25 |  | GETPIVOTDATA fn | GETPIVOTDATA fn | GETPIVOTDATA fn | GETPIVOTDATA fn
26 |  |  |  |  |  | 26 |  | GETPIVOTDATA fn | GETPIVOTDATA fn | GETPIVOTDATA fn | GETPIVOTDATA fn
27 |  |  |  |  |  | 27 |  | GETPIVOTDATA fn | GETPIVOTDATA fn | GETPIVOTDATA fn | GETPIVOTDATA fn
28 |  |  |  |  |  | 28 |  | GETPIVOTDATA fn | GETPIVOTDATA fn | GETPIVOTDATA fn | GETPIVOTDATA fn
29 |  |  |  |  |  | 29 |  | GETPIVOTDATA fn | GETPIVOTDATA fn | GETPIVOTDATA fn | GETPIVOTDATA fn
30 |  |  |  |  |  | 30 |  | GETPIVOTDATA fn | GETPIVOTDATA fn | GETPIVOTDATA fn | GETPIVOTDATA fn
31 |  |  |  |  |  | 31 |  | GETPIVOTDATA fn | GETPIVOTDATA fn | GETPIVOTDATA fn | GETPIVOTDATA fn
32 |  |  |  |  |  | 32 |  | GETPIVOTDATA fn | GETPIVOTDATA fn | GETPIVOTDATA fn | GETPIVOTDATA fn
33 |  |  |  |  |  | 33 |  | GETPIVOTDATA fn | GETPIVOTDATA fn | GETPIVOTDATA fn | GETPIVOTDATA fn
34 |  |  |  |  |  | 34 |  | GETPIVOTDATA fn | GETPIVOTDATA fn | GETPIVOTDATA fn | GETPIVOTDATA fn
35 |  |  |  |  |  | 35 |  | GETPIVOTDATA fn | GETPIVOTDATA fn | GETPIVOTDATA fn | GETPIVOTDATA fn
36 |  |  |  |  |  | 36 |  | GETPIVOTDATA fn | GETPIVOTDATA fn | GETPIVOTDATA fn | GETPIVOTDATA fn
37 |  |  |  |  |  | 37 |  | GETPIVOTDATA fn | GETPIVOTDATA fn | GETPIVOTDATA fn | GETPIVOTDATA fn
38 |  |  |  |  |  | 38 |  | GETPIVOTDATA fn | GETPIVOTDATA fn | GETPIVOTDATA fn | GETPIVOTDATA fn
39 |  |  |  |  |  | 39 |  | GETPIVOTDATA fn | GETPIVOTDATA fn | GETPIVOTDATA fn | GETPIVOTDATA fn
40 |  |  |  |  |  | 40 |  | GETPIVOTDATA fn | GETPIVOTDATA fn | GETPIVOTDATA fn | GETPIVOTDATA fn
41 |  |  |  |  |  | 41 |  | GETPIVOTDATA fn | GETPIVOTDATA fn | GETPIVOTDATA fn | GETPIVOTDATA fn
42 |  |  |  |  |  | 42 |  | GETPIVOTDATA fn | GETPIVOTDATA fn | GETPIVOTDATA fn | GETPIVOTDATA fn
43 |  |  |  |  |  | 43 |  | GETPIVOTDATA fn | GETPIVOTDATA fn | GETPIVOTDATA fn | GETPIVOTDATA fn
44 |  |  |  |  |  | 44 |  | GETPIVOTDATA fn | GETPIVOTDATA fn | GETPIVOTDATA fn | GETPIVOTDATA fn
45 |  |  |  |  |  | 45 |  | GETPIVOTDATA fn | GETPIVOTDATA fn | GETPIVOTDATA fn | GETPIVOTDATA fn
46 |  |  |  |  |  | 46 |  | GETPIVOTDATA fn | GETPIVOTDATA fn | GETPIVOTDATA fn | GETPIVOTDATA fn
47 |  |  |  |  |  | 47 |  | GETPIVOTDATA fn | GETPIVOTDATA fn | GETPIVOTDATA fn | GETPIVOTDATA fn
48 |  |  |  |  |  | 48 |  | GETPIVOTDATA fn | GETPIVOTDATA fn | GETPIVOTDATA fn | GETPIVOTDATA fn
49 |  |  |  |  |  | 49 |  | GETPIVOTDATA fn | GETPIVOTDATA fn | GETPIVOTDATA fn | GETPIVOTDATA fn
50 |  |  |  |  |  | 50 |  | GETPIVOTDATA fn | GETPIVOTDATA fn | GETPIVOTDATA fn | GETPIVOTDATA fn
51 |  |  |  |  |  | 51 |  | GETPIVOTDATA fn | GETPIVOTDATA fn | GETPIVOTDATA fn | GETPIVOTDATA fn
52 |  |  |  |  |  | 52 |  | GETPIVOTDATA fn | GETPIVOTDATA fn | GETPIVOTDATA fn | GETPIVOTDATA fn