How to summarize a row in a calendar report?

Question

SQL

Calendar report:

Presentation of data for the report:

CREATE VIEW ReportEncyclPublicLastCount
AS
  SELECT [Year], [Month], [MonthName], [MonthEnd],
         [1], [2], [3], [4], [5], [6], [7], [8], [9], [10], [11], [12], [13], [14], [15], [16], 
         [17], [18], [19], [20], [21], [22], [23], [24], [25], [26], [27], [28], [29], [30], [31]
    FROM 
      ( SELECT YEAR(PublicationLast) AS [Year], 
               MONTH(PublicationLast) AS [Month],
               DATENAME(MONTH, PublicationLast) AS [MonthName],
               DAY(EOMONTH(PublicationLast)) AS [MonthEnd],
               DAY(PublicationLast) AS [Day]
          FROM EncyclPage ) AS enDay
    PIVOT ( COUNT([Day])
     FOR [Day] IN ( [1], [2], [3], [4], [5], [6], [7], [8], [9], [10], [11], [12], [13], [14], [15], [16], 
                 [17], [18], [19], [20], [21], [22], [23], [24], [25], [26], [27], [28], [29], [30], [31])
          ) AS enPivot

Row Amount is a calculated field on the client.
How to get the amount on the server side?

Answer 1

SELECT [1] + [2] + [3] ... AS [MonthSum], ...
In case of null values ​​add COALESCE