pivot table issue to show values

Ask a Question

Hi All,

I want repeated records for the Late scenario in the months between Due date and completion date.

Ex:

Course Name	Completion Date	Due Date	Jan-16	Feb-16	Mar-16	Apr-16	May-16
05-03-GSOP_001_POLICY FOR COMMUNICATION AND TRANSFER OF INFORMATION	17/05/2016	30/01/2016	Incomplete/Late	Late	Late	Late	Late
QUA-0267_003_QUALITY RECORDS - NEWARK	31/05/2016	05/03/2016
QUA-0134_004_NEWARK- PRODUCT AND PROCESS MONITIORING	31/05/2016	11/03/2016
DSOP 060_005_REWORK	31/05/2016	19/03/2016
15-01-03-006-WI_003_INTER-FACILITY MATERIAL TRANSFER	18/05/2016	07/01/2016
16-01-01-001-WI_002_xxxxx FORMS AND TEMPLATE DOCUMENTS	18/05/2016	21/01/2016

In late place i want to show count of employee number.

can any one please help me.

Thanks,

0 Replies