Another way is to do it at source.

In your source data add another column and call it 2006 Sales

Assuming your data has dates in col A and customer in column B, then in your
new column use a formulas such as:-

=SUMPRODUCT(--($B$2:$B$1000=B2),--(YEAR($A$2:$A$1000)=2006))0

and copy down.

This will give you a TRUE/FALSE against each record as to whether or not
they had a purchase in 2006.

Now simply drag that field into the page fields and select FALSE.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------
It's easier to beg forgiveness than ask permission :-)



"Krish" wrote:

I have a spreadsheet with two worksheets. The first worksheet is a Pivot table with Rows "CustomerID", Column "SalesRep" and the data is Sales for 2006. The second spreadsheet is Customer Master file with "CustomerID" and "SalesRep". I want to find out which customer did not buy during 2006. I am looking for a formula to produce minimal data. The Customer Master is 3000 rows, while the Pivot table has only 932 rows. Any help is truly appreciated