Show certain row based on input value

[damirm86]

Hi

I have a table looking like this:

I want to only show the row where column "Accumulated %" is the same as the value in TargetCoverage, in this case 95%.

My current expression in "Accumulated %" looks like this:

rangesum(above(total sum(DSP_ORD_VOL2)/Sum(TOTAL <[Supplier No]>(DSP_ORD_VOL2)),0,Key))

[Anil_Babu_Samineni]

May be this?

If(

rangesum(above(total sum(DSP_ORD_VOL2)/Sum(TOTAL <[Supplier No]>(DSP_ORD_VOL2)),0,Key)) = $(TargetCoverage),

rangesum(above(total sum(DSP_ORD_VOL2)/Sum(TOTAL <[Supplier No]>(DSP_ORD_VOL2)),0,Key)))

[damirm86]

I have already tried that one without result unfortunately...