QuestionHow 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.
IF YEAR([Order Date]) = 2014
THEN [Pivot Field Values]
IF YEAR([Order Date]) = 2015 THEN [Pivot Field Values] END
SUM([2015 Values ]) - SUM([2014 Values])
( SUM([2015 Values ]) - SUM([2014 Values]) ) / SUM([2015 Values ])
Drag [Pivot Field Names] onto the Rows shelf.
Drag [2014 Values] to Text on the Marks card.
Double-click each calculated field to add them to the view.
Right-click "Pivot Field Names" in the view and select Hide Field Labels for Rows.
Set dashboard to the resolution of the audience's screen
Hide titles for all but the first worksheet added to the view
Right-click [Measure Names] and uncheck Show Header
Add column titles with Text objects
Set all of the worksheets to fit width
Use blank objects to add space where needed
In Tableau Desktop 10.4+, set padding on the Layout pane to 0 for all worksheets