Reporting on table, some fields need to be shown as rows and some fields need to be shown as column

[rajasekharteja]

Hello All,

I have requirement where I need to create Report as below,

Table structure in service now,

Number	Project Name	Compliance Score	OnTime Delivery	qc Coverage	Health
PRO0001016	Project D	67	70	70	Red
PRO0001014	Project C	90	100	60	Green
PRO0001012	Project B	50	100	70	Red
PRO0001015	Project A	70	80	80	Red

Report to be represented as below,

	Project A	Project B	Project C	Project D
Compliance Score	70	50	90	67
OnTime Delivery	80	100	100	70
QC Coverage	80	70	60	70
Health	Red(color)	Red(color)	Green(color)	Red(color)

Thanks,

Raj