My use case is this: I am creating a membership database for a school PTO (parent/teacher organization). I have tables named Parents, Teachers, and Students. The Parents and Teachers tables each have columns for Dues and Donations. I would like to be able to report income from membership in terms of Dues and Donations, but also how much of each is coming from Teachers and how much is coming from Parents.
Is there a way for me to do this? I can create a table with columns that roll up values, but if I make my line items “Dues” and “Donations” and have rollup columns for Teachers and Parents, I can only roll up one type of value per column, meaning it only works for one row (either Dues or Donations - I cannot sum Dues in one row and Donations in the next).
If I create a table with line items for “Teachers” and “Parents” and try to roll up Dues and Donations in columns, it still doesn’t work because you can only roll up using one table per column and I’d need to pull from Teachers in one row and Parents in the next.
Sorry if that is confusing, but can anyone help?