Create an excel pivot table to display survey results using filters.

We are in the process of creating a survey that analyses consumers buying habits.

The survey will contain between approx. 20 product purchased questions (e.g. type of product, model number, where did you buy this product or where did you first see this product) as well as a number of key demographics (e.g. age, gender, region, home tenure and marital status).

We want to be able to upload the data to the excel file with the pivot table once a month and refresh results, thus allowing the user to view the latest statistics.

We then want the user to be able to click on multiple selections to drill down further. For example, you might want to see the results of people who live in the North East of England, are aged between 45-54 and purchased their product from Amazon.

It would be good to have charts but raw numbers and percentages are probably more important of the two.

-I have attached something we have put together on the back of watching a 15 minute Yu Tube video which shows at least the direction we are travelling in. We know it can be done much better.