Hi,

I have been reading the forum and elsewhere looking for a neath solution to my problem. I have some staff survey data that I need to be able to present results for all staff and then at the subset level of job function, section worked in etc. I also want to be able to compare the same questions from this survey and the previous one. What I would like to be able to do is update my results for each subset of interest (job function, section worked in etc) and then save this data before moving to the next report.

I've looked at using a Pivot Table filter but It seems restrictive regarding the layout of the report. The results seem to only go horizontal and I want them vertical. I've attached a spreadsheet showing some sample data and the desired output.

From the spreadsheet

The sheet called Data shows the transformed raw data, basically the survey was a likert scale and 1 represents agreement with the question and 0 any other answer. I'm interested in the percentage of staff that agree.

The Pivot Table Solution sheet displays one solution but I don't want this format.

The Required Report Format sheet displays they layout I'm require.

All help appreciated.

Sample Report.xlsx