cancel
Showing results for 
Search instead for 
Did you mean: 

Create Empty Column in Pivot Table

amelia
10 - ETL
10 - ETL

I would like to have an empty column to create a gap between 2 columns in one of my pivot tables to make it easier to read. Can anyone please advise on this? I tried adding an empty custom column in my cube but it shows up as "N/A"

2 REPLIES 2

harikm007
13 - Data Warehouse
13 - Data Warehouse

Hi @amelia ,

To Add empty dimension column - create custom text column with space

harikm007_0-1664304810976.png

To add empty value column - Create a value panel with formula 1/0 (its a hacky solution)

harikm007_1-1664304896799.png

-Hari

 

 

Interesting! thank you so much