Here's a dynamic PIVOT for you:

DECLARE @TD AS date = GETDATE();

DECLARE @SQL AS varchar(max);

DECLARE @PIVOT_LIST AS varchar(200) = '';

CREATE TABLE #DATA (

artnr int,

customer varchar(20),

custno int,

[status] char(3),

LastResponse date

);

INSERT INTO #DATA (artnr, customer, custno, [status], LastResponse)

VALUES (10007, 'cust1', 2544, 'St1', '20150824'),

(33139, 'cust2', 5173, 'St1', '20150801'),

(33139, 'cust3', 667, 'St3', '20150717'),

(11764, 'cust4', 1746, 'St4', '20150901');

CREATE TABLE #Tally (

GROUPING_DATE date

);

WITH Tally AS (

SELECT DATEADD(day, 1 - DATEPART(DAY, @TD), @TD) AS GROUPING_DATE

UNION ALL

SELECT DATEADD(month, -1, GROUPING_DATE)

FROM Tally

WHERE DATEADD(month, -1, GROUPING_DATE) >= DATEADD(month, -11, DATEADD(day, 1 - DATEPART(DAY, @TD), @TD))

)

INSERT INTO #Tally (GROUPING_DATE)

SELECT *

FROM Tally;

SELECT @PIVOT_LIST = @PIVOT_LIST + '[' + LEFT(REPLACE(CONVERT(char(10), GROUPING_DATE, 112), '-', ''), 6) + '],'

FROM #Tally

ORDER BY GROUPING_DATE;

--PRINT @PIVOT_LIST;

--DROP TABLE #Tally

SET @SQL =

'WITH ALL_GROUPS AS (

SELECT LEFT(REPLACE(CONVERT(char(10), T.GROUPING_DATE, 112), ''-'', ''''), 6) AS GROUPING_DATE, D.[status]

FROM #Tally AS T,

(SELECT DISTINCT [status] FROM #DATA) AS D

),

SELECTED_DATA AS (

SELECT X.[status], X.GROUPING_DATE, COUNT(*) AS ROW_COUNT

FROM (

SELECT D.[status], D.LastResponse, LEFT(REPLACE(CONVERT(char(8), DATEADD(day, 1 - DATEPART(day, D.LastResponse), D.LastResponse), 112), ''-'', ''''), 6) AS GROUPING_DATE

FROM #DATA AS D

) AS X

GROUP BY X.[status], X.GROUPING_DATE

),

GROUPED_DATA AS (

SELECT DISTINCT SD.[status], T.GROUPING_DATE, ISNULL(SD.ROW_COUNT, 0) AS ROW_COUNT

FROM ALL_GROUPS AS T

LEFT OUTER JOIN SELECTED_DATA AS SD

ON T.GROUPING_DATE = SD.GROUPING_DATE

)

SELECT [status], ' + LEFT(@PIVOT_LIST, LEN(@PIVOT_LIST) - 1) + '

FROM GROUPED_DATA

PIVOT (SUM(ROW_COUNT) FOR GROUPING_DATE IN (' + LEFT(@PIVOT_LIST, LEN(@PIVOT_LIST) - 1) + ')) AS PVT

WHERE [status] IS NOT NULL;';

PRINT @SQL;

EXEC (@SQL);

DROP TABLE #Tally;

DROP TABLE #DATA;

Let me know if that works for you.

EDIT: fixed the number of months of data this generates down to 12 from 13, which I discovered after doing the other fix. This edit just fixes the original post to at least do 12 months of data instead of 13.