Hi,

I have a set of data pertaining to several product lines and for several
regions.

Data is in column mode with following info:
Region
Product Line
Component
Date of recording data

On a given date of data recording, a component can either be in the list or
need not be there (thus max 1 record, min = no record).

Via pivot table I have generated following view:

Column headings = Date of recording data
Row headings = component name
The cells (intersection col and row) I have put the "count of component name".

This gives me a series of 1 or 0.

I would like to generate similar view but instead of "count of component
name" I would prefer to see the change from the previous date (i.e. either 0
or +1 or -1). Is it possible to generate this with pivot table?

Many thanks in anticipation.