A
Angela
Hi,
How can I use pivot table to reflect my data table in following
manner:
DATA TABLE
item serial
abc 110
abc 111
abc 112
abc 114
def 760
def 761
def 762
PIVOT TABLE
---------------------------------------
item countofserial start_serial end_serial
abc 3 110 112
abc 1 114 114
def 3 760 762
Can calculated fields help?
But how do I use em to show the actual serial also in pivot & also
pivot will club 'abc' item as 4 & not 3 & 1 as there is a serial
missing in sequence.
Thanks.
How can I use pivot table to reflect my data table in following
manner:
DATA TABLE
item serial
abc 110
abc 111
abc 112
abc 114
def 760
def 761
def 762
PIVOT TABLE
---------------------------------------
item countofserial start_serial end_serial
abc 3 110 112
abc 1 114 114
def 3 760 762
Can calculated fields help?
But how do I use em to show the actual serial also in pivot & also
pivot will club 'abc' item as 4 & not 3 & 1 as there is a serial
missing in sequence.
Thanks.