?

[xyz1]

.

[effinty2112]

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