Hello -

I have the below data set.

Product Period Item
A Q1 1
B Q1 2
C Q1 3
D Q1 4
A Q2 4
B Q2 3
C Q2 2
D Q2 1

I'm using a Pivot Table to look up the number of items for each product by
quarter. So I have Product and Period in my rows, and Items is in my data
set.

So the Pivot Table looks like this.

Sum of Item
Product Period Total
A Q1 1
Q2 4
A Total 5
B Q1 2
Q2 3
B Total 5
C Q1 3
Q2 2
C Total 5
D Q1 4
Q2 1
D Total 5
Grand Total 20

I need to add another line only within the pivot table (not the source data)
that looks at the difference between Q2 and Q1.

How do I code this?

Please help, thanks.