|
1. General Dynamic display, which controls the display and hiding of dashboard content and formatting by setting conditions, such as hiding rows and columns of data, setting conditional formatting, and so on. The following describes the implementation of several typical dynamic display requirements. 2. Realization Dynamic display is mainly realized by cell filtering and highlighting. •Dynamic display of rows and columns (1) If you want to specify a line, a column of data is completely hidden, right-click to select the hidden rows, hidden columns, you can also set the row height, column width of 0, for example, to hide the rows of yellow cells in the following chart: The hiding effect is as follows: (2) If you need to set the hidden cell there is an extension, such as binding the "region", "currency", "amount", and set up a vertical expansion, which contains the currency of CNY and USD, as follows: Want to hide the currency of the data row for the dollar, you can select the "currency" cell, click the "data" area of the "cell filter", set the filter conditions "Currency is equal to [CNY]": The results are as follows: •Display data by condition 1) Dynamic display of the current data according to the value of another cell For example, the green cells in the figure below, want to parent cell according to the "regional number" of different values to the dynamic display, the number 10001 is to show Shanghai, 10002 when the display of Beijing; Specific Steps: Select the green cell, click [Settings>Analysis>Highlight], set the highlighting conditions in the pop-up window, select the format as text, and enter Shanghai and Beijing, respectively, as follows: If, in addition to the text value, you want to set other formats, such as font style, size, background color, etc., you can set them in the area above the format above. The effect is as follows: 2) Extended data, want to control a certain condition only part of the data displayed There are multiple fields within the free table with parent-child dependencies, as shown below, where the parent-child relationship is inherited from top to bottom and left to right; You want to display only CNY when the region number is 10001, and only USD when the region number is 10002, so as to realize the display of different currencies in different regions; The steps for realization are as follows: Select the green cell, set the highlight condition, select Text for Format, and enter a space in the text box: b) If in addition to the text value, you also want to set other formats, such as font style, size, background color, etc., you can set the above format above the area. The effect is as follows: If you want to fulfill this requirement by means of cell filtering, you need to copy the same copy of the metadata cell, as in the yellow marked section below: (a) respectively set the area number cell filter conditions for 10001, 10002 b) Then set the currency number to 1001, 1002 respectively Preview to see the results: ➢Attention: Before setting up highlighting conditions or cell filtering, make sure that the cell extensions are set up with the correct parent-child relationship; cells with parent-child dependencies will affect each other. •Production of multiple dashboards There are times when we need to make multiple copies of the same dashboard in a single grid, i.e., multiple copies, such as in the figure below: Realization Ideas: (1) The whole through the free-form form to achieve, for example, we need a quadruple, you need to free the table is divided into four pieces of the same area, and then in the first area of the binding data fields or fill in the constants, according to the data field dependencies set the parent cell, the following chart: (2) and then in 2, 3, 4 region in turn bound the same data fields, and then set the region 2 "Account Name" parent cell for the region 1 "Account Name", the region 4 "Account Name"parent cell for the region 3 of the"Account Name", the following chart: 3) In order to make each account name on a separate page, we need to set up New page before for the account name in region 1, as shown below: 4) Preview to see the effect as follows: (5) in practice, for different account names, the need to show different number of copies, such as account number aaaa in triplicate, account number bbbb in quadruplicate, account number cccc in duplicate, we can use cell filter and highlight to achieve. First of all, the account name of region 2 and region 4 set cell filtering, region 2 filtered out cccc, region 4 only left bbbb, the results are as follows: You can see that there are only two lines left for account number cccc, and three lines left for account number aaaa, but the text constants entered in the fourth line are still there, and you need to set highlighting to hide them: respectively, select the account name, amount 1, amount 2, amount 3 constants where the cell, are set up in the fourth region of the "account name" where the cell cell cell1-2 for the vertical parent cell, in the right side of the [Settings>Analysis>Highlight] to add highlight, when the cell1-2 is not bbbb, set the text color for the local background color, such as gray, the following chart: In this way, it is possible to achieve different accounts to display different number of links, as shown below: You can also set the format of the highlight to "Text", the text content of the input space, you can also achieve the same effect, set the following chart:
| 
