Question
How to add additional columns to a crosstab containing multiple measures, aka where each row is a measure.For example, the original crosstab may have two columns for the last two years, and the goal is to add a difference column.
Last Modified Date: 20 Jul 2023
For example, the original crosstab may have two columns for the last two years, and the goal is to add a difference column.
Environment
- Tableau Desktop
Answer
The size and structure of the data set, whether or not all the data displayed has the same number formatting, and the particular view being built will all affect the exact solution needed. All of the below options are demonstrated in the attached workbook. Please be aware, that each solution has its own limitations.CLICK TO EXPAND SOLUTION
OPTION 1: Add and customize a grand totals column
CLICK TO EXPAND SOLUTION
OPTION 2: Overwrite unused dates to create extra columns
CLICK TO EXPAND SOLUTION
OPTION 3: Pivot Measures
CLICK TO EXPAND SOLUTION
OPTION 4: Create separate worksheets for each column and combine them on a dashboard
Additional Information
Tableau Desktop is designed to create views that take advantage of the data's underlying structure to help the audience understand data relationships at a glance. Therefore, another visualization may be better suited to present the data.Consider some of the following suggestions to create views that help your viewers quickly find trends and answer questions:
- Add all measures to the Measure Values card and use color to group measures.
- Add information that would be in additional columns to Tooltip
- Create a highlight table
Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Continue Searching
Knowledge Base
Community
Product Help
Training and Tutorials