Hi Agrim,
Using your sample spreadsheet you only need this script:
Data:
CrossTable(Month,Value)
LOAD *
FROM
Sample.xlsx
(ooxml, embedded labels, table is Sheet1);
Then these expressions in the front end:
Count Allocated =count(DISTINCT {$<Employee = E({<Value -= {0}>})>}Employee)
Count Over Allocated =count(DISTINCT {$<Value = {"<0"}>} Employee)
Count Available =count(DISTINCT {$<Employee = E({<Value = {"<0"}>})>} Employee)
Allocated Employees =concat(DISTINCT {$<Employee = E({<Value -= {0}>})>}Employee,', ')
Over Allocated Employees =concat(DISTINCT {$<Value = {"<0"}>} Employee,', ')
Available Employees =concat(DISTINCT {$<Employee = E({<Value = {"<0"}>})>} Employee,', ')
Regards
Andrew
