How to use fractile on subset after fractile is used to divide set in four quartiles

[vvira1316]

Hi,

I've a scenario where I've a set of data for Sales information. I've found 0.25, 0.5, and 0.75 Fractile  value for it, After that I'm displaying Quartile 4, Quartile 3, Quartile 2, and Quartile 1 based on comparing Sales value to the corresponding Fractile values obtained.

Now I've to find 0.5 Fractile Sales value within each Quartile and Summarize for the user.

Please advise how I should do it.

Here is the sample data set

Sales Total Rank Quartile

$976,086.50 1 Quartile 4

$783,245.41 2 Quartile 4

$753,885.56 3 Quartile 4

$745,304.97 4 Quartile 4

$723,718.25 5 Quartile 4

$722,650.89 6 Quartile 3

$709,379.75 7 Quartile 3

$668,184.24 8 Quartile 3

$648,683.39 9 Quartile 3

$620,118.76 10 Quartile 3

$617,171.31 11 Quartile 2

$608,873.66 12 Quartile 2

$529,959.86 13 Quartile 2

$511,669.81 14 Quartile 2

$492,137.29 15 Quartile 2

$418,783.34 16 Quartile 1

$365,804.68 17 Quartile 1

$349,612.03 18 Quartile 1

$340,318.39 19 Quartile 1

$322,617.31 20 Quartile 1

Thanks,

Vijay