I am trying to apply a value filter in a pivot table, but the options are
greyed out. Why could this be.

The scenerio, I have a huge file, with client data. I want to see this data
broken down 1st by Sales Manager, 2nd by client. I can get this far. Now I
would only like to see data for "Total" sales over 100K. The value filter is
not available.