Last Modified Date: 04 Jan 2019
Option 1: Convert the field to a continuous measure
- Right click the field in the data pane and, if available, select "Convert to Measure".
- Optional: Right click the field in the data pane again and change the aggregation of the field (Default Properties > Aggregation > (Desired Aggregation).
- Drag this field on the Measure Values Card.
This option may not work for all use cases. For example, if you want to display a String in the column, see Option 2.
Option 2: Use container fields
Step 1: Create calculated fields for each measure used
- For every measure that you want to include in the view, select Analysis > Create Calculated Field.
- Name the field. Consider including the name of the measure in it. For example, Order Col.
- In the Formula field, type 0, and then click OK.
Step 2: Build the view
- Drag Region, Order Date, and Row ID to Rows.
- Drag Segment to Columns.
- Drag each calculated field that you have created to Columns.
- In the ALL Mark card, ensure the Text is selected as a Mark Type.
- In each mark card, drag the associated string value or measure to Text. For example, drag Order ID to Text in the SUM(Order Col) mark card.
Note: if there is more than one string value per line this step will cause overlapping values.
- Right-click each measure on the axis and select Edit Axis
- Navigate to the Tick Marks tab > select None for Major tick marks and Minor tick marks, and then click OK.
- In the Rows, right-click any of the calculated field and select Format.
- Click the Lines icon and navigate to the Columns tab.
- In the Zero Lines drop-down menu, select None.
- In the Grid Lines drop-down menu, select None.
Step 3: (Optional): move titles to the top
- For each desired column in the finished crosstab, drag two copies of the calculated fields created in the directions above to Columns.
- Drag the measure to Text in both copies of the calculated field.
- Right-click on the second copy of the calculated field on the Columns shelf and select Dual Axis.
- Edit both the top and bottom axes as desired.
CauseOnly aggregated and continuous fields can be added to the Measure Values Card.
Discuss this article...
Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Training and Tutorials