Adding An Empty Row In A Cross Tab

Published: 02 Jul 2020
Last Modified Date: 26 Oct 2022

Question

Adding an empty row in a cross tab

Environment

Tableau Desktop

Answer

Scenario 1: If there is no dimension used in rows
Example: Adding an empty row between sales and profit with order date in columns

1. Create a calculation called Empty like below:
INT(NULL)
2. Use Empty between measure values like below:

User-added image

3. Edit the alias of the measure to a space

Scenario 2: If there is a dimension in rows
Example: Adding an empty row between members belonging to Category dimension

1. Create a calculated measure for every dimension member.
For example: Created a calculated field for Sales belonging to Furniture, Technology and Office supplies

IF [Category]="Furniture"
then
[Sales]
end

IF [Category]="Technology"
then
[Sales]
end

IF [Category]="Office Supplies"
then
[Sales]
end

2. Use Empty between measure values

User-added image