Как сделать общее количество строк в сводной таблице?

---

Я хочу настоящего,отсутствующего,CL,H

Date     1    2      3      4   5    P  CL  A
Emp1     P    P      P      P   CL   4  1   0
Emp2     CL   SL     P      P   H    2  2   0
Emp3     A    A      A      P   H    1  0   3

Пожалуйста, помогите.

Что я уже пробовал:

я пытался преобразовать столбец в строки,Теперь я хочу A, P,CL

ALTER Procedure [dbo].[Pivot_Attendance2]
--@StartDate Date,
--@Enddate   Date

As  
Begin 

SELECT DISTINCT ReportingDate INTO #Datess
FROM EmployeesAttendance
--WHERE     (ReportingDate BETWEEN @StartDate AND @Enddate)
ORDER BY ReportingDate

DECLARE @cols NVARCHAR(4000)
SELECT  @cols = COALESCE(@cols + ',[' + CONVERT(varchar, DATEPART(DAY, ReportingDate), 112)
				+ ']','[' + CONVERT(varchar,DATEPART(DAY, ReportingDate), 112) + ']')
FROM    #Datess
ORDER BY ReportingDate

DECLARE  @qry NVARCHAR(4000) =
N'SELECT * 
FROM (SELECT     EmpID,  CASE WHEN [Days] IS null AND EXISTS
                          (SELECT     1
                            FROM          EmpApplication
                            WHERE      EmployeesAttendance.Empid = EmpApplication.Empid AND 
                            (ReportingDate >= LeavFrom AND ReportingDate <= LeavTo))
                             THEN ''CL''
                             WHEN [Days] IS null AND
                       EXISTS
                          (SELECT     1
                            FROM          Holidays
                            WHERE      ReportingDate = HolidayDate) 
                            THEN ''H'' 
                            WHEN [Days] IS null THEN ''A'' WHEN [Days] = 1 THEN ''P'' END AS Status,
         DATEPART(DAY, ReportingDate)as DDate FROM EmployeesAttendance )emp


PIVOT (MAX(Status) FOR DDate IN (' + @cols + ')) AS stat 
            ORDER BY RNO_ROWTOTAL,''p'';

'
-- Executing the query

EXEC(@qry)
 
END

---