Show TOC

# Examples: Calculate Single Values As

Overview of Functions

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

Calculation direction
The calculation direction is always from the top in the direction of the drilldown.
• 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.

Table 1: Example query with Sales in the filter and Customer and Region in the drilldown:
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