Last Modified Date: 23 Feb 2017
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, Sales Col.
- In the Formula field, type 0, and then click OK.
Step 2: Build the view
- Drag Region to Rows.
- Drag each calculated field that you have created to Columns
- In the ALL Mark cards, ensure the Text is selected as a Mark Type.
- In each mark card, drag the associated measure to Details and to Color. For example, drag Sales to Details in the SUM(Sales Col) mark card.
- Modify the color of each measure as desired.
- 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.
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 the Columns shelf
- Drag the desired 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
Additional InformationTo view these steps in actions, see the video below:
Note: It will not be possible to sort the measures by clicking on the axis after using this solution, but it will still be possible to sort by right-clicking Region and sorting by a specific measure. See How to Sort Data (Computed Sorts) for more information.
Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Training and Tutorials