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

Please Login or Register  to view this content.

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

Please Login or Register  to view this content.

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

Please Login or Register  to view this content.

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