Teacher Count = COUNTD(Teacher ID)
Program Count= COUNTD(Program ID)
Participant Count= sum(COUNTD(Participant Count))
Please try the follwing
I doubt if the student count will work. As I said that's just sample data. Distinct cannot be applied and count cannot be used here. Any other suggestions?
Had it been SQL I can do SUM() based on partition of School ID. with tableau its a challenge for me.
If all the values are identical you can do SUM(AVG(Participant Count)) (Or SUM(MIN(... or SUM(MAX(... )
I think some of this might be dependent on how you have the sheet layed out too.
Thanks Joe and Alexander. I think I got the idea the using the double aggregates based on your solutions. That might solve my problem for now. I was thinking if there could someway to get the final total in one shot without the school details. May be that's how the data works.
Thanks for the help again.
Thanks a lot Alexander. That works perfectly.