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