WPS How to sell high sell low no contrast also know

Source: Internet
Author: User

If we want to check the highest selling price and the lowest selling price of a product in a day's sales record, we don't need a constructor or an expression. We can use the following methods to obtain.

First step: Select the next column in the table title bar, and then click the Freeze Pane button under the View tab.

Step two: Switch to the Start tab, select the table header row, click the "Filter" List button, click on the "Filter" command, then the right of each cell in the title appears a small triangle button, can perform the drop-down operation.

Step three: Select the desired date from the Date Drop-down box (for example, March 5, 2014) and select the desired product name (such as a refrigerator) from the "Name" Drop-down box (Figure 3) so that the list will contain only the March 5, 2014 sales of refrigerators.

Step Fourth: Right click on the status bar blank, select the "Max" and "Min" two options from the menu (Figure 4).

Fifth step: Select all the "unit price" cell, in the status bar can see the refrigerator to sell the highest price and the lowest price.

Small tip:

With the system built-in automatic calculation and status bar prompts, you can also calculate the average number of data. Cleverly to the status bar prompt information to switch settings and reasonable use, can be in the daily calculation of a lot of convenience.

Related Article

E-Commerce Solutions

Leverage the same tools powering the Alibaba Ecosystem

Learn more >

Apsara Conference 2019

The Rise of Data Intelligence, September 25th - 27th, Hangzhou, China

Learn more >

Alibaba Cloud Free Trial

Learn and experience the power of Alibaba Cloud with a free trial worth $300-1200 USD

Learn more >

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.