Advanced Techniques: Combine Columns to Display Data Differently
You can combine columns based on set operations such as Union or Intersect. By combining columns, you create a column for displaying the data in a different way.
For example, you can combine a Region column with a City column and create a column named Regions and Cities.
The analysis must meet certain criteria if you want to use set operations:
-
The number and data types of the columns must be the same.
-
You can’t use hierarchical columns, selection steps, or groups when you combine criteria.