Without being able to see your data, I'd suggest that you can't put an LOD (the FIXED statement) in a table calculation (the RANK_PERCENTILE function)

Hi Ishita,

I think the error is saying that the fields you use in the table calcs must be aggregate.  Even though you have the sum calcs inside your LODs, the LODs themselves are not aggregate.

Try this:

RANK_PERCENTILE(sum({FIXED [Status]:sum([measure])}))<=0.75 and RANK_PERCENTILE(sum({fixed [Status]:sum([measure])}))>=0.25

Let me know if that works for you.

Best,

Paul

Hi Ishita,

When you say that the calculation didn't work, did it not give you what you expected or did it give you an error?  Can you share a screenshot of it?  Also, can you share your tableau file too so we can see what that looks like?

Thanks,

Paul

Hi Ishita,

Thanks for attaching your workbook.  I don't think you need the LOD part of the calculation at all.

I believe I got it working the way you want in the attached workbook.  Here's the updated P25 to P75 calculation:

RANK_PERCENTILE(sum([Measure]))<=0.75 and RANK_PERCENTILE(sum([Measure]))>=0.25

Then you have to make sure to select Compute Using > Cell so that it computes the percentiles within each column.

Here's what it looks like in the updated workbook

Let me know if you have any questions.

Best,

Paul

Awesome, glad it works!  Happy to help!