How do i do this count in script or expression

[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 

[cquezada87]

Well, you already know that you must order it in such a way that when you do the count you can identify where you are going to do it and it is very important to place ID for the names of students and teachers in addition to the classes.

Greetings.

[D19PAL]

Thanks

Can you send me the code for this please.

[cquezada87]

LOAD ID_NOMBRE,
NOMBRE_USUARIO,
ID_GERENTE,
NOMBRE_GERENTE,
ID_CLASE,
NOMBRE_CLASE,
ID_POSICION
FROM
[C:\Users\cquezada\Documents\Libro1.xlsx]
(ooxml, embedded labels);

Expresion in qlikview = count(ID_POSICION)