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.