Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
how to display count of employees in each department in the below table format
load * from employee;
load * from department;
department | count(employees) |
---|---|
sales | 10 |
HR | 10 |
finance | 25 |
corporate | 45 |
Total | 90 |
whenver I clik on concerned department those details are to be displayed in ohter table
i.e. when i click i slaes all the 10 records are to be displyed as below
department | employee number | Emplyee type | salary | country | manager |
---|---|---|---|---|---|
sales | 1 | Regular | 40k | IND | XXX |
sales | 2 | Temp | 50k | IND | YYYY |
... | ... | .... | ..... | ||
sales | 10 | temp | 60k | IND | ZZZZZ |
in script--
load *
from tablename;
load
department,
count([employee number]) resident tablename group by department;
****************************************
in expression--
Aggr(count([employee number]),department)