SerenityNetworks
Board Regular
- Joined
- Aug 13, 2009
- Messages
- 131
- Office Version
- 365
- Platform
- Windows
I simply want to count the number of students in a class. In my example, I have:
4 in Class 1,
3 in Class 2,
3 in Class 3,
6 in Class 4,
3 in Class 5, and
6 in Class 6.
I want to use the values in a Pivot Chart (as shown in the attached image). The formula I have now works, but it seems rather kludgy.
Class Size:=COUNTAX(FILTER('Table2',[Passed]="y"),[Class]) + COUNTAX(FILTER('Table2',[Passed]="n"),[Class]) + COUNTAX(FILTER('Table2',[Passed]="n/a"),[Class])
I imagine there is a better way to get the count of students in a class, but I'm struggling with the structured references syntax. Any help will be appreciated.
4 in Class 1,
3 in Class 2,
3 in Class 3,
6 in Class 4,
3 in Class 5, and
6 in Class 6.
I want to use the values in a Pivot Chart (as shown in the attached image). The formula I have now works, but it seems rather kludgy.
Class Size:=COUNTAX(FILTER('Table2',[Passed]="y"),[Class]) + COUNTAX(FILTER('Table2',[Passed]="n"),[Class]) + COUNTAX(FILTER('Table2',[Passed]="n/a"),[Class])
I imagine there is a better way to get the count of students in a class, but I'm struggling with the structured references syntax. Any help will be appreciated.