excluding the values from pivot table once the target reached

[JJaky]

Hello,

I'm totally new to QlikSense, so please bear with me.

I'm making a pivot table, and I'd like to remove the values once I reached the target (100%), how can I do that?

Thanks for any hints in advance.

[edwin]

you can do a rangesum and then test if the rangesum >= your threshold.  here is a great piece on rangesum.  it was written for QlikView but should also work for Qlik Sense

Running totals per dimension (RangeSum(), sortable... - Qlik Community - 1487351