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:

Product	Brand	Category	Jan Qty	Jan Sales	Feb Qty	Feb Sales	Mar Qty	Mar Sales
Item 1	Brand 1	Cat 1	5	$500	4	$400	7	$700
Item 2	Brand 2	Cat 1	20	$50	30	$75	10	$25
Item 3	Brand 2	Cat 2	6	$60	5	$50	10	$100
Item 4	Brand 3	Cat 2	10	$250	30	$750	10	$250

<tbody>
</tbody>

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