How to do a group by using the output as column header

[herbert1682]

SELECT * FROM
(SELECT DISTINCT Invoice, Medical_Center, Year, Month FROM Denials_Scrub_Final) AS BaseData
Pivot (
COUNT(Invoice)
FOR Medical_Center
IN([BCHO], [UCSF],[UCD],[UCLA],[UCI],[UCSD])
)
AS PivotTable

------------------------------------

I need to do this in Alteryx

[cmcclellan · Accepted solution]

I think this is what you're trying to do:

- a Summarize tool, with Invoice, Medical_Center, Year and Month as Group and Invoice as Count 

- then a Cross Tab tool, grouping by all the columns above except;

• New Column Headers = Medical_Center
• Values for New Columns = Invoice Count

[herbert1682 · Accepted solution]

This worked