Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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