Pivot Pie Chart - Drop Down Selection Help

Hi All,

I have a list of data from a 2011 census and what I want the pivot chart to do is have a drop down menu in Sheet1 - the drop down menu is a filter from the pivot chart - Postcodes. Once you check the post code it brings up a pie chart of the data, thus being the language spoken in the post code.

I'm having alot of trouble trying to get this to work. ANY help would be appreciated

Thank you