how can I create a dimension in which I choose the pacients by percentile?

[alejortizp]

Hi,

Im trying to make a dimension that identify the percentile that i want for later make a filter. i just rank my patient but i could not identify his percentile.

rank(Aggr(sum([Autorizaciones.COSTO_SERVICIO]), [CONTRATO_AFIL]))

this sentences doesnt work just put 0.5%:

if(rank(Aggr(sum([Autorizaciones.COSTO_SERVICIO]), [CONTRATO_AFIL]))*.0105<rank(Aggr(sum([Autorizaciones.COSTO_SERVICIO]), [CONTRATO_AFIL])),'0.5%','otros')

Thanks

[sibusiso90]

This can be achieved in the script and you don't have to create a calculated dimension.

[alejortizp]

Hi,

I have this code "num(rank(Aggr(sum([Autorizaciones.COSTO_SERVICIO]), [CONTRATO_AFIL])))/num(rank(Aggr(sum(total [Autorizaciones.COSTO_SERVICIO]), [CONTRATO_AFIL])))" .

This code tell me where is the accumulated of patients for know where is de percentile of this patients. But i want to filter for the 1% or 0.5% or 5% or 10% of this patients and not to filter manually. How i can do that?