Summary Field Help
I have a portal on a tab control which shows school enrollment information. The portal shows the info for school for that particular school district (Main Table). The portal lists school names, the year and enrollment information. Out side the portal, I have created a total field where I summarize the enrollment numbers for that school district. I want to be able to summarize based on school type (public, private and charter) which are assigned to each school. Then I need a total of all schools. I only want to summarize the most current year info. How do I do this? Do I need four separate total fields, one for each school type and one for grand total? How do I write the equation?
Thank you for your help in advance.