conditional rows in table

[#1]

Hi,

I have a lot of data from our laboratory, and we have a field TAT (turn around time).

I need to make a table where only the rows of the table are shown where the TAT is bigger than 90% of all TAT's.

The condition is something like this: TAT > fractile(TAT,0.90)

But I don't know where or how to put it in my table.

Any help?

Thx!

[deepakk]

hi,

First you need to create pivot table. Add the required dimesnion and in Expression try the below code.

sum(if(TAT > fractile(TAT,0.9), TAT)).

[Anonymous · Accepted solution]

In situations like this I often create a calcualted dimension. Use your condition in the dimension calculation.