Adding An Empty Row In A Cross Tab
02 Jul 2020
Last Modified Date:
08 Jul 2022
Adding an empty row in a cross tab
If there is no dimension used in rows
Adding an empty row between sales and profit with order date in columns
1. Create a calculation called
between measure values like below:
3. Edit the alias of the measure to a space
If there is a dimension in rows
Adding an empty row between members belonging to Category dimension
1. Create a calculated measure for every dimension member.
Created a calculated field for Sales belonging to Furniture, Technology and Office supplies
IF [Category]="Office Supplies"
between measure values
Did this article resolve the issue?
Thank you for providing your feedback on the effectiveness of the article.
Click here to return to our Support page.
Open new Case
Open a new case
Click here to go to our Support page.
Get detailed answers and how-to step-by-step instructions for your issues and technical questions.
Find and share solutions with our active community through forums, user groups and ideas.
Browse a complete list of product manuals and guides. Available online, offline and PDF formats.
Training and Tutorials
Learn how to master Tableau’s products with our on-demand, live or class room training.
PRINT THIS PAGE
SUPPORT BY PRODUCT
TOOLS & DOWNLOADS
Download Tableau Desktop & Server
Tableau Online & Public Status
Send Large Files
All Tech Specs
Elite Account Management