Hi, I’m not new to Airtable but I’m still very novice. I’m sure there is a way to do this but I can’t figure it out.

I run a horse show association where our members earn points. They can earn awards in 3 different areas, all are captured within our Airtable bases. I figured out groups and then adding the sum to the summary row. But how do I get an output for this, into a report or html I can insert into our website? Here is an example of what I’m trying to do:

Name - Class - Division - Points

John - Apples - Fruit - 5

John - Oranges - Fruit - 4

John - Green Beans - Vegetables - 3

John - Asparagus - Vegetables - 2

So I need to be about to output 3 things - total points (all points added together) so for John this would be 14 points. Then I need John’s points by Division - so for John this would be Fruit - 9 and Vegetables 5. Then I need it for each Class - so Apples - 5; Oranges - 4; etc.

I can get my bases sorted/grouped to give me the sums correctly, but then I don’t know what the next step is to produce a report that is usable and postable for our website.

Thanks in advance for all help!