To filter time series data displayed in the table, use the Filtering group on the View side panel tab or the Filter button on the Home or Data ribbon tab.
To enable filtering:
Select the filtering mode in the drop-down menu of the Filter button on the Home or Data ribbon tab.
Select the Hide Values checkbox and choose a filter mode in the View side panel tab:
All Empty Columns. All empty table columns are hidden.
All Empty Columns Before Start/After End Periods. All empty table columns only to the right and to the left from the time series are hidden.
To disable filtering:
Release the Filter button on the Home or Data ribbon tab or select the No radio button in the drop-down menu of this button.
Deselect the Hide Values checkbox in the View side panel tab.
See also: