Putting similiar records from different table underneath each other in a pivot table

[asmith5rgv]

Good morning all. I have 2 tables in XL. One table has prior year information and the other year has current year info. Both table have the following simple structure:

Month / Major Descr / Units

My pivot table has the months as rows and the item code as column.

I want my data to look like this:

ITEM CODE / MONTH 1 / MONTH 2/ MONTH 3/ MONTH 4 / ETC ETC
Current Year abc123 10 20 30 10 15
Prior Year abc123 5 15 25 10 13
Current Year xyz321 10 20 30 10 15
Prior Year xyz321 5 15 25 10 13

In other words, put the data from the prior year table underneath the Current Year data grouping by Item code

I created a relationship but when I put the units fields from both tables in the Values pivot box it puts the current and previous amounts side by side as a column, not underneath each other.

I dont know how well I have explained this but any help would be appreciated.

Alan