Categorize pivot table

[flygstolen_fred]

Hi,

I have a SQL table with sales data that I want to "categorize" in a pivot table.

InvoiceLines:

SKU	Price	Cost	Units	Date
123	120	90	2
124	98	45	1
125	75	70	1

I want to categorize my pivot table to look like this:

	Jan	Feb	Mar
Sales	sum(Price*Units)	sum(Price*Units)	sum(Price*Units)
Cost	sum(Cost*Units)	sum(Cost*Units)	sum(Cost*Units)
Profit	sum((Price-Cost)*Units)	sum((Price-Cost)*Units)	sum((Price-Cost)*Units)

How do I create categories like in the left column? Any help are appreciated.