0
Former Member
Feb 08, 2007 at 07:41 AM

# Statistical reporting

16 Views

Hi Colleague,

I have a lot of measurements in a cube, f.i.: sales per customer at a certain time is one measurement. Let's say I have 10 measurements:

Meas----

Sales

1----

20

2----

5

3----

8

4----

47

5----

4

6----

25

7----

11

8----

2

9----

62

10----

44

I want a report with only the 10% value and the 20% value(% according to nr of measurements) of the sales for customer X. Calculation:

1. First sort the sales and redefine the measurement nr:

Meas----

Sales

1----

2

2----

4

3----

5

4----

8

5----

11

6----

20

7----

25

8----

44

9----

47

10----

62

2. The total nr of measurements = 10 so the 10% measurement will be 10/10 = nr. 1. The 20% measurement will be (10/10)*2 = nr. 2:

Meas----

Sales

1--

2--(10%)

2--

4--(20%)

3----

5

4----

8

5----

11

6----

20

7----

25

8----

44

9----

47

10----

62

This has to result in the following report:

Customer-- -10% ---20%

X--

2--

4

Off course, if f.i. there are 90 measurements in the cube the 10% measurement will be nr. 9 and the 20% measurement will be nr. 18.

Is there anyone who could help me?

Kind regards!