Filtering not available for Pivot Table

[originalogy]

I'm working with some sample data for a department store's sales and commissions. I want to have the first and last names and commission amount for each sales person and sort the data ascending by commission. The filter button isn't available, even though I've turned on the "Allow multiple filters per field" option in Pivot Table Options.

What am I missing?

Thank you

 

[xenou]

It may be easiest to work with your source data to add a new field of "First and Last Name" (use concatenation to put the two names together into one field). Then your pivot table can just be "First and Last Name" and "Commission".

Hope this helps,
Alex