I have been given a very challenging job - I'm not feeling too confident about it actually but I'm giving it a go. A colleague gave me a task which he used to do in Excel - analyse the results of a multiple choice quiz. I'm starting with the simple part - display a graph for some of the key questions which shows the percentage of responses in a data set for each of the answer options. The answers are represented as 0,1,2,3, 4; or no answer. I need to sum the number of times each option appears, then display as a percentage. I've done an exercise which summarises a percentage of sales for each sales person; but that obviously adds the numbers, not their occurrences. I've searched but obviously not searching the correct terms. Any clues much appreciated. Thanks very much.

And how is the data organized into records and fields?

Assuming that your data model is similar to your sales chart excersize, it might be very close to what you need. There are summary fields and aggregate functions that can count records instead of summing them.