Skip to main content
Announcements
SYSTEM MAINTENANCE: Thurs., Sept. 19, 1 AM ET, Platform will be unavailable for approx. 60 minutes.
cancel
Showing results for 
Search instead for 
Did you mean: 
MikeJones
Creator
Creator

Pivot Table Blank Row

Hi, I have a pivot table that I have entered a blank row see Pivot table 1.  However the dashes appear.

In Pivot table 2, I have entered in the Expression =''.  The dashes disappear, though the label shows as ='.

My Ideal Pivot table is shown where there isn't a label showing and no dashes showing. 

How can I get to the Ideal Pivot?

MikeJones_0-1688634865411.png

 

Labels (2)
1 Reply
vinieme12
Champion III
Champion III

Create an inline table and add blank rows using a blank space character

Dim_PnL_Report:
Load dual(Dim,recno()) as Dim,recno() as so_Dim
inline [

Dim,SortORder

Revenue,1

<PASTE BLANK SPACE CHARACTER HERE>‎,2

Costs,3

];

 

You can copy the blank space character from below

https://www.editpad.org/tool/invisible-character

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.