How to calculate Top/Bottom Quartile of a column

[#1]

Hello,

Urgent!

Could you please tell me how do I calculate Top/Bottom Quartile of a column in a pivot table.

Any input/suggestions are highly appreciated. Thanks.

[sunny_talwar]

Use Fractile function:

Fractile(FieldName, 0.25) -> For 1st Quartile

Fractile(FieldName, 0.75) -> For 3rd Quartile

[#3]

Thanks much for prompt response Sunny.

Actually, FieldName I have is "Sum(Meetings)". If I put like this Fractile(Sum(Meetings), 0.25), its giving me an error saying nested aggregate functions are not allowed.

I tried using master items but no luck.

Moreover, I am trying to identify what is bottom or top quartile of a Meetings field and shade red for bottom and green for top quartiles.

Can you please guide me thru how to achieve this.

[reddy-s]

HI Kishore,

As Sunny mentioned the fractile() should help you. Also check these out.

Re: Fractile with Calculated Field??

Thanks,

Sangram.

[sunny_talwar]

You would need a Aggr function between your Fractile and Sum functions:

Fractile(Aggr(Sum(Meetings), AggregatingFieldsHere), 0.25)