Filter data in a DataView Web Part using SharePoint Designer

Follow the steps to filter the Overall Project Status by its Status, Assume that we need to list all the project that are in open status.

1. Open the page that contains the Data View that you want to filter.
2. Right-click the Data View, and then click Show Common Control Tasks on the shortcut menu.

3. In the Common Data View Tasks list, click Filter.
4. In the Filter Criteria dialog box, click Click here to add a new clause.
5. Select more fields from Field Name drop down
6. Select the field Status field and Click Ok
7. Enter the value as Open in the Value field and click OK
8. 
9. Save the file and refresh the page to verify the webpart.