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))