Alright, I'm really, really new to pivot tables, and haven't really figured out what all they're capable of, yet. Largely I just want to be pointed in the right direction!

I have a spreadsheet with two worksheets on it. On the first one is a huge spreadsheet with sales data. Date, amount, item #s, salesperson, and so on. On the second worksheet is a list of employees and how long they've been employed. It's just years, so employee ID #s in the first column, integers 0 through 15 or so in the second.

I'm trying to use a pivot table to start analyzing the data on the first worksheet. But something that's really important for me to do is to only show data for people in a certain range of experience. So I might want to see what is being sold by people with less than one year of experience. I think this sounds pretty simple, but I'm just not sure how to do it. Can anyone get me on the right track?