Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi I have some survey data where questions are answered with a score 0-6. I am trying to create a table/grid that show the % of respondents for a given score by item:
EG:
Header 1 | Header 2 | Header 3 | Header 4 | Header 5 | Header 6 | Header 7 | Header 8 |
---|---|---|---|---|---|---|---|
0 | 1 | 2 | 3 | 4 | 5 | 6 | |
Item ID 1 | 5% | 15% | 20% | 23% | 17% | 10% | 10% |
Item ID 2 | 3% | 17% | 23% | 20% | 10% | 17% | 10% |
Any ideas where to start? Any suggestions gratefully received.
The data is stored as a filed called the ITEM ID# and consists of a series of scores between 0 and 6
If your table shows two fields, Item and Score, you can create a pivot table chart with these two dimensions, and a single expression
=Count(Score) / Count(TOTAL<Item> Score)