Multi values pivot fields and how to remove all zero value rows?

Hi

Is it possible to remove zero values from pivot results when there's more than one values pivot field being used? I'm aware of the filter function but it's limited to one field I think so not sure how to tackle this?

Simple example attached where the pivot is showing all rows but the desired outcome is a far smaller data set when I've manually pasted the pivot outputs and deleted the blank value rows.

I'm wondering if there are other dynamic array solutions now with 365 so a pivot may not be appropriate but it's nice and easy and somthing people are familiar with so easier to pass on the workbook

Thanks

No the real data may have multiple value fields populated for each row of source data

Great that will work. Sorry you couldn't just briefly outline the creation steps could you?

Amazing, thankyou!