When you filter on the column, you will only see Jones and Smith but there is no way of knowing how many Jones's and Smith's there are. Imagine I have 100,000 records with say 250 different surnames. How would I know what the breakup of each surname is by just filtering. The filter will simply give me the unique surnames not the number of thimes they occur. Hope that's clearer.