Not sure if this is possible, but I thought I would put this out there and see what anyone thought.
Report: I need to track by classroom the parents that have given vs. those that I have not. I had created this awesome report with those that had, but I could never figure out how to pull the parents who hadn't yet in to the report. I need those that have not as well to create a sum and percentage of parents each class. (first query was too narrow, the next one gave too many dates and gifts, which duplicated the names in the report)
So I'm trying a different route and took the data from an Export instead of a Query, but now the "Classroom Guide" field is in a separate column for each child they have at the school.
I need to combine the 4 Guide fields somehow so I can group by them to create the classrooms in the report.
Makes sense?
Example data is like:
first.name;last.name;Guide1;Guide2;Guide3;Guide4;Gift.Date;Gift.Amount