I am trying to compare similar records from two different sources.
I would like to identify those 'Item's where the Qtys are different.
The data sheet looks like the following:
Source Item Qty
(see attached file also)
File A X 10
File B X 10
File A Y 2
File B Y 3
File A Z 8
File B Z 4
I created a PivotTable with the following fields:
Row Labels = 'Item'
Column Labels = 'Source'
Values = 'Qty' (sum)
The data records for the 'Column Label' called 'Source' contains only 'File A' or 'File B'.
Is there a way to create a 'Calculated Field' within the PivotTable that can display the difference between the 'Qty' of the two Sources?