Scorecard Filtering: How do I prevent the body from rendering under certain conditions.

[matt.lothamer]

I have a scorecard which has a member filter. When I filter on a value there will be some repeated bodies (rows, or whatever they're called) rendered that have no data. How do I prevent the bodies with no data from rendering or prevent them from rendering under certain conditions (i.e. TotalQuantity = 0)?

Below is an example from this support article. What I would want to do is only show Canada and the other rows would not be displayed at all.

Thanks,

Matt.

[elia.scher]

The screenshot is from section 4.1 Filter only the control. This process intends to filter only the values and not the hierarchy to the left, which is why you first detach the control from the metric set. If you do not detach the control from the metric set, the result would be exactly what you are looking for.