I. Overview
1) Conditional formatting can control row height, so you can hide data by conditional formatting.
2) Prerequisites: Insert Data Columns, An Introduction of Conditional Formatting.
You will learn |
---|
|
II. Steps
1. Create a new dataset [ds1]
1) Create a new DB query dataset.
2) Drag the table [Product] into the DB query.
2. Drag data columns into cells
1) B3~E3: Drag data columns [Product_name], [SupplierID], [Inventory_quantity] and [Order_quantity] into cells.
2) B2~E2: Input the header and fill them with grey.
3) B2~E3: Set as central alignment and add borders.
4) Preview.
3. Select D3 and add condition
4. Setting of property
1) Click + to select the property: Row Height.
2) Row Height: 0MM.
5. Add common condition
1) Operator: greater than or equal to.
2) Value Type: Integer.
3) Comparison Value: 10.
4) Click+ to add the common condition.
6. Preview
Only the number of inventory less than 10 is displayed and others are hidden.
7. Add formula condition
1) Type: Formula. Click Edit.
2) Define the formula as D3 >= E3. Click OK. (Data columns [Inventory_quantity] and [Order_quantity] are inserted into D3 and E3 respectively)
3) Select the logical operator: AND.
4) Click + to add the formula condition.
8. Preview
Only the number of inventory less than 10 or less than the order quantity is displayed and others are hidden.