Hello, I'm new here and I really need HELP. Im sorry for my english(not a native speaker) But I really hope you can help me...
I'm in a new job and boss wants a report from me, but I don't know how to do it. Im pretty decent with Excel, even really good with VBA but Pivot tables are hell for me.
I have a sheet of date with ratings of sales reps. Columns are Date,Sale_Rep_Name,Num_of_questions,Rating,Change,Rating_After_change. Every row is a rating of a Sales rep by customer, num of questions says how many questins did the cust. answer (max 4 questions). Rating is the rating given by cust. Change says if there was a manual change of rating by my boss (could be becouse the cust. didnt really understand the questionnaire) if there was something bad with the question(change = 1) then rating is changed to 1.
What I need to show on my report is connection between changes and number of questions. For example, would there be a less manual changes if we counted only ratings where cust. answered all four questions?
How to do this?
Bookmarks