Pivot table: how to count unique? need help!

Giganews Newsgroups
Subject: Pivot table: how to count unique? need help!
Posted by:  luiss
Date: Wed, 14 Jun 2006

this a table similar to the one I really have
serialnb    label
111    a
111    b
222    a

I want to create a pivot that shows how many *unique* serials exist, and
also per label, etc.
Doing the "usual" pivot I get the following

Count of serialnb        
serialnb    label    Total
111    a    1
    b    1
222    a    1
Grand Total    3
        
How can I show the results I want? (should be 2 for unique serial numbers)
Many thanks!
luis

Replies