I have a database with 20 columns and about 15,000 rows. To use a pivot
table I then use an advanced filter to select the months records that I want
in the pivot table.
The problem is that records that match the filter sometimes aren't in the
extracted data.
Entry is put it by batches and the missing records, when there are some, are
always the first record of a batch entry.
If i copy the record and insert in the same place and change values on the
first line - everything works fine. But I can't count on accurate results.
What is wrong?