How do i get this count in a table

[D19PAL]

Hi,

How do i get this count in a table 

Data

Name, Manager,ID,Class,Position 

John,james,1,art,student

Dan,james,2,art,student

James,simon,3,art,teacher

Tony,peter,4,art,student

I need to count by position, how many Name and Manager have the same Class, 

So group 1 is Class Art John and Dan share a class with their Manager, so I want to show John, Dan and the Manager James.

Table

Class,Position,Total

art,student,2

art,teacher,1

Table 2

ID,Name,Class,Count

1, john,art,1

2, Dan,art,1

3,James,art,1

Thanks much appreciated 

[Ryan69]

---

@D19PAL wrote: Portal4me Login

Hi,

How do i get this count in a table 

Data

Name, Manager,ID,Class,Position 

John,james,1,art,student

Dan,james,2,art,student

James,simon,3,art,teacher

Tony,peter,4,art,student

I need to count by position, how many Name and Manager have the same Class, 

So group 1 is Class Art John and Dan share a class with their Manager, so I want to show John, Dan and the Manager James.

Table

Class,Position,Total

art,student,2

art,teacher,1

Table 2

ID,Name,Class,Count

1, john,art,1

2, Dan,art,1

3,James,art,1

Thanks much appreciated 

---

I appreciate the information and advice you have shared. I will try to figure it out for more.

[D19PAL]

Hi Ryan,

Any luck with this?

Thanks