Filters in Google Spreadsheets allow you to analyze data in your document by showing only the things you want. However, it also changes how others see the document. Here's how you can use filter views to keep the view of each employee unchanged.
Start Google Spreadsheets and open a spreadsheet to get started.
Click Data> Filter Views> Create New Filter View.
For this guide we want to filter there is something in the table that has a price per unit of more than $ 10. Click the filter icon in the "Price per unit" field.
For this following part you can choose to filter by values or conditions to analyze your data. "Filter by value" provides a simple way to view data and choose specific values in the column. "Filter by condition" offers you a much more detailed approach ak with the option to add custom formulas to find data.
First, click on "Filter by condition" to expand the section, then click on the "Then" drop-down list option.
RELATED: How to mark a row in Google Sheets with conditional formatting
Enter the conditions for the filter and Click the OK button".
Now you can see all products that cost more than $ 10 per unit without disturbing the view of other contributors. 
Because you can only switch one filter at a time, you can stack filters for each column to increase your data analysis potential. All you have to do is click on one of the filter icons and repeat the same process.
To disable all filter views, click the "X" in the upper right corner of the sheet.
If you want to enable a filtered view again, click Data> Filter Views and then choose a filter to view.
Although this is a very basic use of a filtered view, its use seems to be unlimited, you can stack multiple filters and even add custom formulas to store your data. analyze and sort without disturbing other people you work with.