Setting a Rank Value in Expression

[#1]

All,

I am trying to set a rank value as a column in a straigt table but I am unsure the exact expression.  My data set is as follows:

Location	Exceptions	Rank
A	5
B	8
C	3
D	6
E	9
F	5
G	2
H	4

I want the expression in "Rank" column to return a value A(<.25), B(.25 to .50), C(.50 to .75), D(>.75) based on quartile value of exception against total exceptions.

There are multiple dimensions so i would need this to aggregate.

Thanks

[sunny_talwar]

Try this as your expression.

=If(Exception < Fractile(TOTAL Exception, 0.25), 'A', If(Exception < Fractile(TOTAL Exception, 0.5), 'B', If(Exception < Fractile(TOTAL Exception, 0.75), 'C', 'D')))

Also please find atttached a qvw file.

Best,

S