In it's basic form, Tableau can only format based off one value. For example, you can have a chart that displays Sales and Profit, but you can only color based on one of them.
|Profit and Sales by Region (Colored by Profit)|
|Profit and Sales by Region (Colored by Measure Values)|
- Create a meaningless calculated field
- Drag the Calculated Field onto the "Columns" Shelf
- Change the "Mark" Type to "Text"
- Right-Click inside the Column -> Select "Format" -> Click the Icon that looks like a Pen, -> Remove "Zero Lines"
- Right-Click on the Axis Header (which is ironically at the bottom) -> Select "Edit Axis" -> Change the Title to something reasonable
- Still in the "Edit Axis" Window, open the "Tick Marks" Tab -> Select "None" and "None"
- Drag the Desired Measure onto the "Text" Shelf
- Resize the Column
|Single-Column (Dual-Axis?) Crosstab|
Now, you've created a "Single-Column Dual-Axis Crosstab." Realistically, we aren't going to use the "Dual-Axis" component in this post; however, I'm not sure what else to call it.
- Drag the "Field" Calculated Field to the "Columns" Shelf and place it beside the previous one
- Next to the Word "Marks" above the "Marks" Shelf, Select the "Down Arrow" -> Select "Multiple Mark Types"
- Now, you can cycle between your different fields
- Drag another measure to the "Text" Shelf for the new field
- Repeat "Step 2" to clean this column up as well
- Repeat the above process for adding any more measures you want
- Add any dimensions you would like to the "Rows" Shelf
|Completed Dual-Axis Crosstab|
EDIT: Some readers have been asking for a workbook illustrating this concept. Zen Master Jonathan Drummey has a very good workbook illustrating this technique posted here.