I have a chart (a pivot table, technically) that summarizes purchases/spending by customer.
What I am trying to do is allow my client to choose to see only those that have spent within a specified range...say $200-$300.
Is there a way to do this? The owner of the company doesn't like the little built in search/magnifying glass at the top of the summarized column as it's quite small and if a client doesn't know what it is or why it's there, then they can't use it. He wants some sort of box where the client can key in 200 and 300 and see their customers who fall into this range.
Is this even possible? If so, can someone please tell me how? I have seen the input boxes but they seem aimed at variables and I could not quite figure out if these would or could be helpful.
Thanks for any help you may be able to provide!
