Set your sort and filter settings for selected
rows.
Touch the spark line (mini chart) of a dedicated
row in
TM1 View
grid
to add the row header (i.e. "Betriebsleistung")
to the sort and filter settings.
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.
Select comparing operators (i.e. "* like") and
edit comparing values (i.e. "act" for actual)
for filtering columns:
Push the "Back"- or "OK"-button to apply the
sort- and filter settings.
Filter result -Version * like act- =
showing "Actual" columns only:
Filter tip
Specify more than one filter value using comma
(,) as a separator (without a blank):
Filter result -Company *
like porto,nova,garibaldi / Version *
like act-:
Select comparing operators and enter min/max
values for further column filtering:
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-:
For removing a sort/filter entry completely,
delete the row's header name, i.e. Betriebsleistung:
and confirm by pushing the "OK"-button. All
specifications for this filter will be removed.
Next
grid settings