Hello,

This is a summary of how I have the data organized:
- Company name
- Company quintile according to revenue
- Answers 1 to n: answers given by each company to certain questions

Company Revenue quintil Answer1 Answer2 ...
A I Yes Yes
B II Yes No
C III Yes Yes
D IV No Yes
E V No Yes
F I No No
G II Yes No
H III Yes Yes
I IV Yes Yes
J V Yes No

I'd like to have a summary table showing per quintile, the % of all companies answering "Yes" to each question, it is:

I II III IV V
Answer1 50% 100% 100% 50% 50%
Answer2 50% 50% 100% 100% 50%

If this is not posible, it would be also useful to have information under each answer showing the number of answers "Yes" and "No":

I II III IV V
Answer1
Yes 1 2 2 1 1
No 1 0 0 1 1
Answer2
Yes 1 1 2 2 1
No 1 1 0 0 1

I'd appreciate any help you can provide.

Thanks a lot!