Change Matrix Column Setting

Follow the procedure below to change the settings of the added matrix column.

1. Select "Setting" from the matrix column header menu.

2. Column Setting dialog will be displayed with three tabs of "Basic Property", "Series" and "Child Column".

Basic Property

Unlike normal column setting dialog, you can only change the settings for the header label.

Series

In the Series tab, you can change settings related to the matrix column series.

• [A] Display Interval - Change the display interval of time series items. Select from the following values:

  • Yearly

  • Quarterly

  • Monthly

  • Weekly

  • Daily

• [B] Start - Set the first date of the time series to display. You can specify a date directly from the calendar, but you can also select relative dates (e.g., "Today", "Next Month"). You can also use the Reference Value Selection Button [※] to select reference values and dynamically change setting values. For details on reference values, see "Reference Value".

• [C] Period - Specify the period to display time series as a numerical value. Must specify an integer value of 1 or greater. You can also use the Reference Value Selection Button [※] to select reference values and dynamically change setting values. For details on reference values, see "Reference Value".

• [D] Date Format - By setting a date format, you can automatically generate series display labels in the specified format. This is particularly useful when start dates or periods change dynamically. Checking Specify header display labels individually [E] allows you to customize series display labels individually.

• [F] Series Menu - Toggle the display/hide settings for series (hidden series values are displayed with grayed text)

Child Columns

You can check the child columns to be displayed inside the matrix column. It is also possible to hide each child column, or make the hidden child columns visible (hidden child columns are displayed with grayed text).