How to quickly filter out data above average in WPS table

We can use wps tables to process data. There is a filtering function in WPS tables. We can use this function to filter and search our data. So if we want to quickly filter out the content we want, how do we do it? For example, if you want to filter out table data that is higher than the average value, the editor will introduce the method below. Method step 1. Enter the required content in the form, then position the mouse to the [Start] tab at the top of the page, and then click the [Filter] button in the toolbar.

2. At this time, we can see that a triangular drop-down icon button will appear on the title row.

3. For example, if you want to filter the data above the average through [Total], then click the triangle drop-down icon next to [Total], and click [Above average] in the window that opens.

4. After completing the operation, return to the table editing page. You can see that the current table content is filtered according to the total data being higher than the average, as shown in the figure.

5. In addition, if you want to find data below the average, then we can just click below the average.

The above is the detailed content of How to quickly filter out data above average in WPS table. For more information, please follow other related articles on the PHP Chinese website!