KNOWLEDGE BASE

Adding An Empty Row In A Cross Tab


Published: 02 Jul 2020
Last Modified Date: 03 Jul 2020

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
Did this article resolve the issue?