Pivot Table only show data when totals above 0

[MikeJones]

I have a pivot table with results for some 450 engineers.  Below is snapshot of my results.

When I go into the dimension Engineer and set the limitation to exact value > 0, I get the following.

For Mike Jones the totals are the same.  The weekly data that is displayed doesn't show data for WB 18 and 25 Nov 2024 as the CAT Score is 0.  How can I get my pivot table to:

1. Show all of the data aslong as CAT Score is above 0 or Total PC is 2 or more  or Total WIP is 2 or more?  Below is an example of the final pivot I would like to see

[rubenmarin]

Hi, diemnsion limits are applied using the first measure.

You can build your custom limitation using a calculated dimension

Change the Engineer dimension to:

Aggr(If([CAT_Expression]>0 and [PC_Expression]>=2 and [WIP_Expression]>=2, Engineer), Engineer)

And uncheck the dimension option to include null values.

[MikeJones]

Hi Ruben, thanks for your reply.

I have introduced as a dimension =Aggr(If([CAT_Expression]>0 and [PC_Expression]>=2 and [WIP_Expression]>=2 and Not Match(Engineer, '.') and Len(Trim(ResourceManager)) > 0 Engineer), Engineer) together with

and I get only a dash for an engineer.

[MikeJones · Accepted solution]

Hi Ruben, I made an error when copying your formula.  It now works brilliantly.

Thank you for your time.