G
gmj105
Complex to me anyway.
Say I have a bunch of customer survey data in an Excel 2007 table with the
following format:
Date, Customer, Region, Rating
I want to pivot the data is such a way that I group certain types of scores
(10,9,8 = Great, 7,6,5 = Good, 4,3,2,1 = Bad) against region, and quarter (or
some other date filter). I can't seem to do this, but to complicate the
matter, I would also like to add a calculated value using the three counts
((Great + Good)/(Great + Good + Bad)):
Great Good Bad %Favorable
Q1 10 12 8 73%
--North Region 6 3 5 64%
--South Region 4 9 3 81%
Q2 13 6 5 79%
-- North Region 8 2 1 91%
-- South Region 5 4 4 69%
Can this all be done in a pivot, or do I have to brush of my VBA skills?
Greg
Say I have a bunch of customer survey data in an Excel 2007 table with the
following format:
Date, Customer, Region, Rating
I want to pivot the data is such a way that I group certain types of scores
(10,9,8 = Great, 7,6,5 = Good, 4,3,2,1 = Bad) against region, and quarter (or
some other date filter). I can't seem to do this, but to complicate the
matter, I would also like to add a calculated value using the three counts
((Great + Good)/(Great + Good + Bad)):
Great Good Bad %Favorable
Q1 10 12 8 73%
--North Region 6 3 5 64%
--South Region 4 9 3 81%
Q2 13 6 5 79%
-- North Region 8 2 1 91%
-- South Region 5 4 4 69%
Can this all be done in a pivot, or do I have to brush of my VBA skills?
Greg