TM1 View grid
The TM1 View grid is presenting your TM1 data according to the TM1 View layout design and data selected in front by the title elements:
graphic
The formatting of figures is corresponding to the selected culture (settings).
Drill down/up
graphic
Root and parent elements of the row subset provide a "+"-button for drill down/up.
graphic
All children of the parent receive the color of the button border. Pushing the drill-button is changing the color of button-border and child-fonts.
Row selection
graphic
Touch the header name of the row to select the row. Selecting a parent row will select all related children synchronously. If the children are hidden - drilled up -they will not be selected, but the parent only.
Column sorts and filters
Touch the spark line (mini chart) of a dedicated row
graphic
to add the row header (i.e. "Betriebsleistung") to the TM1 View grid filter settings.
Sort result -Betriebsleistung ascending-:
graphic
See "Selected" function button below how filtering columns by chart selections.
 
Grid functions
graphic
Function button
action

graphic

Refresh the TM1 data displayed in the TM1 View grid if you are using Device mode  and staying online.

graphic

Deselect all selected rows, even hidden children of parent rows.
Alternatives:
Select/deselect all children of a parent row (visible/drilled down) by a touch/click on the parent header name.
Select/deselect a single row by a touch/click on the single row's header name.

graphic

Expand all nodes (parent row drill down) to display all data rows of the TM1 View.

graphic

Selected rows are displayed, all unselected are hidden.
Push the "Selected"-button again to reset the grid to the view state before.
Special tip - filter columns by chart selections:
When returning back from charts to grid - after your chart selections are done - push the "Selected"-button for filtering the grid columns to your corresponding chart selections.

graphic

Collapse all nodes (parent row drill up) to display the root node only, like your first entry in the TM1 View grid.

graphic

Filter settings are edited in TM1 View grid filter settings. The "Filter"-button's border turns blue, if sort definitions exist and turns red, if filter settings are reducing grid columns to corresponding filters.

graphic

Color settings are edited in TM1 View grid color settings.
You can change the font color of a single row by selecting or deselecting the row (touch the row header name) and push the "Color"-button.
You can change the font color of all row children if you just drilled down the parent row (push "+"-button) and push the "Color"-button.

graphic

Chart your grid rows and columns with corresponding row colors in TM1 View chart.
 
Quick guide
Advanced grid functions
TM1 View grid filter settings
Set your sort and filter settings for selected rows. 
Touch the spark line (mini chart) of a dedicated row in TM1 View grid 
graphic
to add the row header (i.e. "Betriebsleistung") to the sort and filter settings.
graphic
Select ascending / descending for the definition of the sort order of columns determined now by the related cell values of the specified row (i.e. "Betriebsleistung").
Push the "Back"- or "OK"-button to apply the sort- and filter settings.
Sort result -Betriebsleistung ascending- in TM1 View grid:
graphic
Select comparing operators (i.e. "* like") and edit comparing values (i.e. "act" for actual) for filtering columns:
graphic
Push the "Back"- or "OK"-button to apply the sort- and filter settings.
Filter result -Version * like act- = showing "Actual" columns only:
graphic
Filter tip
Specify more than one filter value using comma (,) as a separator (without a blank):
graphic 
Filter result -Company * like porto,nova,garibaldi / Version * like act-:
graphic
Select comparing operators and enter min/max values for further column filtering:
graphic 
Please don't use comma/point-separators when specifying values (i.e. -4500000) because of the language dependency interpreting the separator: thousands or decimal.
Filter result -Betriebsleistung < less -4500000-:
graphic
For removing a sort/filter entry completely, delete the row's header name, i.e. Betriebsleistung:
graphic
and confirm by pushing the "OK"-button. All specifications for this filter will be removed.
 
Next grid settings
 
TM1 View grid color settings
Set your font colors for selected rows of TM1 View grid
Child rows
You can change the font color of all row children if you just drilled down the parent row (push "+"-button):
graphic
and push the "Color"-button:
graphic
graphic
Touch a color field and you'll get back to TM1 View grid.
Single rows
You can change the font color of a single row by selecting or deselecting the row (touch the row header name in TM1 View grid i.e. "Betriebsleistung") 
graphic
and push the "Color"-button:
graphic
graphic
Touch a color field and you'll get back to TM1 View grid.
graphic
Reset individual color settings
As you changed the color of child rows or of a single row you can reset your individual settings
graphic
by pushing the "Reset"-button for selected row(s)
or by pushing the "Reset all"-button to reset all individual color settings of TM1 View grid.
Special tip - mouse double click (notebook users)
Double click the row header name or one of the row value cells to change the row's font color.
Double click the drill/"+"-button of a parent row to change the font color of all children.
graphic
Next chapter