Google Sheets filters let you analyze data in your document by showing only what you want. However, it also changes as others see the document. To use filter views to leave each employee's view unchanged:
Launch Google Sheets and open a spreadsheet to get started.
Click Data> Filter Views> Create New Filter View.
For this guide we would like to filter everything in the table, the one Price per unit of more than $ 10. Click on the filter icon in the "Unit Price" box.
For this next part, you can choose to filter by either values or conditions to analyze your data. "Filter By Value" provides an easy way to date n and select specific values in the column. Use Filter By Condition to refine the search for data using custom formulas.
First, click "Filter By Condition" to expand the section, click the drop-down box and then click "Larger" as an option.
. RELATED: Marking a line in Google Sheets with conditional formatting
Enter the terms of the filtering and click the "OK" button.
Just so you can now view all products that cost more than $ 10 per unit without affecting the view of other contributors. 
Since you can only switch one filter at a time, you can stack filters for each column to increase the potential for data analysis. Just click another filter icon and try again.
To disable all filter views, click on the "X" in the upper right corner of the sheet.
Whenever you want to reactivate a filtered view, click Data> Filter Views, and then select a filter to display.
Although this is a very basic use of a filtered view, there seems to be no restrictions on its use. You can stack multiple filters and one another. You can even add custom formulas to yours Analyze and sort data without disturbing others Pe which you work with.