Page History
You can combine multiple dimension fields to create a single combined field and display it in the Data Pane.
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.
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.
Combined Field Options
...
You can perform the following right-click actions on an existing combined field.
- 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.