Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

You can combine multiple dimension fields to create a single combined field and display it in the Data Pane.

Image Modified

To create a combined field, select multiple dimensions in the Dimensions Pane and then right-click the fields and select Create Combined Field. The Create Combined Field option is only displayed on right-click when all selected fields are in the Dimensions Pane.

Image Modified

The name of the combined field combines the dimension names in the same order they appear in the Dimensions Pane, appended by (Combined). The values of these dimensions are separated by the specified separator, in this case, a comma.

Image Modified

Combined Field Options

...

You can perform the following right-click actions on an existing combined field.

Image RemovedImage Added

  • Editing the combined field options such as renaming, assigning a new separator, and changing the sequencing of the columns.
  • Creating a copy of the combined field.
  • Renaming the combined field.
  • Deleting the combined field. This action deletes the combined field from all worksheets of the same workbook.

...