Examples: Calculate Single Values As
The following table provides an overview of the following functions: Normalize According to Next Group Level Result, Normalize According to Overall Result and Normalize According to Unrestricted Overall Result:
| Customer | Sales | Normalize According to Next Group Level Result | Normalize According to Overall Result | Normalize According to Unrestricted Overall Result |
|---|---|---|---|---|
Customer 1 |
10 |
10.86 % |
0.97 % |
0.12 % |
Customer 2 |
0 |
00.00 % |
0.00 % |
0.00 % |
Customer 3 |
17 |
18.47 % |
1.66 % |
0.21 % |
Customer 4 |
8 |
08.69 % |
0.78 % |
0.10 % |
Customer 5 |
15 |
16.30 % |
1.46 % |
0.19 % |
Customer 6 |
22 |
23.91 % |
2.15 % |
0.28 % |
Customer 7 |
15 |
16.30 % |
1.46 % |
0.19 % |
Result |
92 |
|||
Overall Result |
1023 |
|||
Query Result |
7812 |
The following table provides an overview of the functions Rank Number and Olympic Rank Number:
| Customer | Sales | Rank Number | Olympic Rank Number |
|---|---|---|---|
Customer 1 |
10 |
4 |
5 |
Customer 2 |
0 |
6 |
7 |
Customer 3 |
17 |
2 |
2 |
Customer 4 |
8 |
5 |
6 |
Customer 5 |
15 |
3 |
3 |
Customer 6 |
22 |
1 |
1 |
Customer 7 |
15 |
3 |
3 |
The following table provides an overview of the functions Maximum and Minimum:
| Customer | Sales | Maximum | Minimum |
|---|---|---|---|
Customer 1 |
10 |
22 |
0 |
Customer 2 |
0 |
22 |
0 |
Customer 3 |
17 |
22 |
0 |
Customer 4 |
8 |
22 |
0 |
Customer 5 |
15 |
22 |
0 |
Customer 6 |
22 |
22 |
0 |
Customer 7 |
15 |
22 |
0 |
The following table provides an overview of the functions Moving Average, Moving Average that is Not Zero, Null or Error and Hide:
| Customer | Sales | Moving Average | Moving Average that is Not Zero, Null or Error | Hide |
|---|---|---|---|---|
Customer 1 |
10 |
10.00 |
10.00 |
|
Customer 2 |
0 |
5.00 |
10.00 |
|
Customer 3 |
17 |
9.00 |
13.50 |
|
Customer 4 |
8 |
8.75 |
11.66 |
|
Customer 5 |
15 |
10.00 |
12.50 |
|
Customer 6 |
22 |
12.00 |
14.40 |
|
Customer 7 |
15 |
12.43 |
14.50 |
In this case (characteristics in the rows and key figures in the column), the calculation direction is from top to bottom.
If the key figures are in the rows and the characteristics are in the columns, the calculation direction is from left to right.
If a query contains characteristics in the rows and in the columns and the query is filtered by a key figure (for example, sales), the calculation begins at the top left and works down to the bottom right.
| Customer | Germany | England | France | Result |
|---|---|---|---|---|
BMW |
10 |
17 |
35 |
62 |
VW |
0 |
15 |
17 |
32 |
Mercedes |
12 |
22 |
3 |
37 |
Result |
22 |
54 |
55 |
131 |
The following table shows the query with the function Normalize According to Overall Result:
| Customer | Germany | England | France |
|---|---|---|---|
BMW |
7.63 % |
12.97 % |
26.71 % |
VW |
0.00 % |
11.45 % |
12.97 % |
Mercedes |
9.16 % |
16.79 % |
2.29 % |
The following table shows the query with the Rank Number function.
| Customer | Germany | England | France |
|---|---|---|---|
BMW |
6 |
3 |
1 |
VW |
8 |
4 |
3 |
Mercedes |
5 |
2 |
7 |
The following table shows the query with the Olympic Rank Number function:
| Customer | Germany | England | France |
|---|---|---|---|
BMW |
7 |
3 |
1 |
VW |
9 |
5 |
3 |
Mercedes |
6 |
2 |
8 |