Comparison Report In Table Or Matrix?

Hi everybody,

I'm having trouble creating a seemingly simple Comparison report.
I want to be able to create a Table or Matrix that displays the number of items for the Current Year, the Previous Year, and the Difference. I was able to write a script that gives me the count for each item, for each year, as illustrated below:









Item
WhichYear
Count

Apples
Current Year
2

Apples
Previous Year
2

Mangos
Current Year
214

Mangos
Previous Year
204

Oranges
Current Year
13

Oranges
Previous Year
20

Pears
Current Year
19

Pears
Previous Year
50

Strawberries
Current Year
28

Strawberries
Previous Year
40

Ideally, the report Layout look like this, with a column for each year, and a separate column for the difference:










Item
Current
Previous
Difference

Apples
2
2
0

Mangos
214
204
10

Oranges
13
20
-7

Pears
19
50
-31

Strawberries
28
40
-12

Sounds simple enough to me. But when I put it in a Table, I can't get the counts for the Current and Previous Years on one line per item. They end up broken down into two lines (as illustrated in the first chart). When I try to add a grouping, it somehow holds onto the Current Year numbers and ignores the Previous Year numbers. When I put it in a Matrix, I can't seem to write a simple calculation, like finding the Difference between the two columns. Can I add a non-pivot row or column to the matrix?

I know this is a very general question... Any idea on whether I should go for a Table or a Matrix or another approach, like a summary table?

Thank you very much in advance,

- Trevor