Hi,

The simplest way is to use your hierarchy ...

As you can drill down from Product A to Product B it means you have an hierarchy defined.

So instead of adding a filter on the "deal amount" add the filter on the "deal amount" aggregated at the "Product A" level. With that kind of filter you will be able to drill down to the levels underneath "Product A" without losing the rows because of the filter.

Here you see the same kind of example, I left the "AGGREGATE("Base Facts"."2- Billed Quantity" AT "Products"."Products Hierarchy"."Brand")" on the screen just for the example to highlight why the rows doesn't disappear, but this column can also not exist and you just add the formula in the filter itself.

So I added a filter on "Billed Quantity" > 40'000, and without the AGGREGATE AT I would lose the "BizTech" row when drilling down from Brand to LOB because both rows are < 40'000. By using the AGGREGATE AT as filter the rows stays on screen because the condition is always evaluated at the Brand level and this allow me to drill down to the 4 levels of the hierarchy and explore the details.