D
DKS
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.
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.