Hello experts,
Quartile needs to be calculated based on Incentive amount.
Granularity is Rep -> Period -> Product -> Incentive.
Fractile function works exact when there is only one dimension and one fact.
With the sample example given below it shows unexpected values. could anyone suggest on this?
Sample data attached below.
Sales Rep | Period | Product | Incentive |
S1 | Q1 | P1 | 100 |
S1 | Q2 | P1 | 25 |
S1 | Q3 | P1 | 21 |
S1 | Q3 | P2 | 99 |
S2 | Q1 | P1 | 132 |
S2 | Q2 | P1 | 12 |
S2 | Q2 | P3 | 35 |
S2 | Q3 | P1 | 200 |
S2 | Q3 | P2 | 200 |
S3 | Q1 | P1 | 200 |
S3 | Q2 | P1 | 50 |
S3 | Q2 | P3 | 100 |
S3 | Q3 | P3 | 250 |
S3 | Q3 | P2 | 200 |
S4 | Q1 | P2 | 150 |
S4 | Q2 | P2 | 100 |
S4 | Q3 | P2 | 300 |
S5 | Q1 | P1 | 500 |
S5 | Q2 | P1 | 100 |
S5 | Q2 | P3 | 200 |
S5 | Q3 | P1 | 150 |