Pivot tables with multiple date columns

[leemcd]

Hi there,
I'm trying to work out how to create 2 different pivot tables from the one table. Here is an example table below:

[TABLE="width: 600"]
<tbody>[TR]
[TD]Product[/TD]
[TD]Brand[/TD]
[TD]Category[/TD]
[TD]Jan Qty[/TD]
[TD]Jan Sales[/TD]
[TD]Feb Qty[/TD]
[TD]Feb Sales[/TD]
[TD]Mar Qty[/TD]
[TD]Mar Sales[/TD]
[/TR]
[TR]
[TD]Item 1
[/TD]
[TD]Brand 1[/TD]
[TD]Cat 1[/TD]
[TD]5[/TD]
[TD]$500[/TD]
[TD]4[/TD]
[TD]$400[/TD]
[TD]7[/TD]
[TD]$700[/TD]
[/TR]
[TR]
[TD]Item 2[/TD]
[TD]Brand 2[/TD]
[TD]Cat 1[/TD]
[TD]20[/TD]
[TD]$50[/TD]
[TD]30[/TD]
[TD]$75[/TD]
[TD]10[/TD]
[TD]$25[/TD]
[/TR]
[TR]
[TD]Item 3[/TD]
[TD]Brand 2[/TD]
[TD]Cat 2[/TD]
[TD]6[/TD]
[TD]$60[/TD]
[TD]5[/TD]
[TD]$50[/TD]
[TD]10[/TD]
[TD]$100[/TD]
[/TR]
[TR]
[TD]Item 4[/TD]
[TD]Brand 3[/TD]
[TD]Cat 2[/TD]
[TD]10[/TD]
[TD]$250[/TD]
[TD]30[/TD]
[TD]$750[/TD]
[TD]10[/TD]
[TD]$250[/TD]
[/TR]
</tbody>[/TABLE]

Ideally I want to create a pivot table where I can collate sales quantities over a month range, and then sort the data via category, or brand etc. Then another pivot table where I do the same but for the Sales$

Any ideas?

Lee