Filter function; Filter both rows and columns

I have a pretty large data set that I am trying to than use a Filter Function to both filter the Rows (for specific regions) and also the columns for both specific period and and specific expense item.

I can use the Filter Function to filter and display either the filtered rows or the filtered columns. But I can't get it to do both in the formula?

Can anyone see where I am maybe going wrong with the below?

This will filter the rows, but returns all of the columns

=FILTER('TTM Stats'!A27:AIZ676,('TTM Stats'!E27:E676=P39))

This will filter the columns, but not all of the rows

=FILTER('TTM Stats'!A27:AIZ676,('TTM Stats'!A26:AIZ26="CY "&P12)*('TTM Stats'!A23:AIZ23=P40))

But when I try either of the below to filter both the rows and the columns, it gives a #Value error?

=FILTER('TTM Stats'!A27:AIZ676,('TTM Stats'!E27:E676=P39)*('TTM Stats'!A26:AIZ26="CY "&P12)*('TTM Stats'!A23:AIZ23=P40))
=FILTER('TTM Stats'!A27:AIZ676,('TTM Stats'!E27:E676=P39)+('TTM Stats'!A26:AIZ26="CY "&P12)*('TTM Stats'!A23:AIZ23=P40))

Hello,
can you please upload a small sample file? please see the yellow banner at the top of the page for further instructions.