Hi everyone -
I've got a spreadsheet which exists to collect data on people leaving the company based on exit interviews done.
The way things are currently set up is that I have three columns devoted to the 3 top reasons for leaving (represented by various codes explained on the paper original), 11 columns with 'ratings' for the Line Manager, and a further 15 columns with 'ratings' for the company itself. Rows are, obviously, allocated to each individual.
The questons about the Line Manager were scored during the interviews requiring the following responses:
Always, Usually, Seldom & Never
The company was scored:
Very Good, Good, Fair, Poor.
What I'm having tremendous difficulty with is how I can get my Pivot Table to give me the interpretations of the data I want. I.e. - a display of what the most common reason for leaving was, what a particular Line Manager consistently scores low on, how leavers feel about the company's Performance-related Pay??
Once I've got the structure in place, I'm sure I could manipulate it around to show most of what I want, but I'm confused about how I can get Excel to interpret the 'Very Good', 'Good' etc. etc. as percentages of the data.
I've considered using a different 'scoring' system, but I'm sure what we're using at the moment must be usable to an extent!
I hope I've explained my query sufficiently!
Any help would be very much appreciated.
Jonathan
I've got a spreadsheet which exists to collect data on people leaving the company based on exit interviews done.
The way things are currently set up is that I have three columns devoted to the 3 top reasons for leaving (represented by various codes explained on the paper original), 11 columns with 'ratings' for the Line Manager, and a further 15 columns with 'ratings' for the company itself. Rows are, obviously, allocated to each individual.
The questons about the Line Manager were scored during the interviews requiring the following responses:
Always, Usually, Seldom & Never
The company was scored:
Very Good, Good, Fair, Poor.
What I'm having tremendous difficulty with is how I can get my Pivot Table to give me the interpretations of the data I want. I.e. - a display of what the most common reason for leaving was, what a particular Line Manager consistently scores low on, how leavers feel about the company's Performance-related Pay??
Once I've got the structure in place, I'm sure I could manipulate it around to show most of what I want, but I'm confused about how I can get Excel to interpret the 'Very Good', 'Good' etc. etc. as percentages of the data.
I've considered using a different 'scoring' system, but I'm sure what we're using at the moment must be usable to an extent!
I hope I've explained my query sufficiently!
Any help would be very much appreciated.
Jonathan