I have Expenses with fields EVENT and CATEGORY and AMOUNT. If I group and sort, I can see the sum of expenses for a particular EVENT by CATEGORY. But . . . I would like to summarize this on a separate table. I would like records which show the sum...
Actually my solution was right in front of me. As a new user I’m still figuring things out!
I just created different views in my original table. I simply filtered to a single event and then grouped by the expense category.
My table is a little more c...
Thank you. This is actually just the beginning of a more complicated table I’d like to create, so the pivot table only gives me part of what I need . . . I’ll keep trying! I appreciate your time!
As I was working through this, I realized what I’m looking for is what I would do as a pivot table in Excel. I don’t know how to do pivot tables in Airtable yet, and frankly, for now, I would be happy to just have it display as a table. Here’s a sc...
