Skip to Content
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!