4 Replies Latest reply: Feb 22, 2016 10:17 AM by Sunny Talwar

# How to calculate Top/Bottom Quartile of a column

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.

• ###### Re: How to calculate Top/Bottom Quartile of a column

Use Fractile function:

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

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

• ###### Re: How to calculate Top/Bottom Quartile of a column

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.

• ###### Re: How to calculate Top/Bottom Quartile of a column

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

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

• ###### Re: How to calculate Top/Bottom Quartile of a column

HI Kishore,

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

Re: Fractile with Calculated Field??

Thanks,

Sangram.