I used to be able to select certain values in a field and drag that field up
to the top of a pivot table so that it locks in those values. So say I
didn't want sales that were already "booked", only those in the pipeline, I
would deselect the booked value and leave the others in. Once I dragged it
up to the top the spreadsheet would show the data based only on those in the
pipeline, not including booked. Don't know why it's not working now when I
go to do that.