The sort is based on all the data in the entire table. Therefore, even when the sort is placed just on "1", it is looking at the entire column. Health Services has the highest value for Spending under President Obama, then Treasury and SSA (also for Obama). Since the President field has a manual sort of placing the Presidents in the desired order making it a little more difficult to see. By filtering out Obama, Clinton is sorted correctly. Hope this helps!