Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Use Fractile function:
Fractile(FieldName, 0.25) -> For 1st Quartile
Fractile(FieldName, 0.75) -> For 3rd Quartile
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.
HI Kishore,
As Sunny mentioned the fractile() should help you. Also check these out.
Re: Fractile with Calculated Field??
Thanks,
Sangram.
You would need a Aggr function between your Fractile and Sum functions:
Fractile(Aggr(Sum(Meetings), AggregatingFieldsHere), 0.25)