cancel
Showing results for 
Search instead for 
Did you mean: 

In a Pivot Table I need to hide a column when no data present but show column when data is present

snicholls
7 - Data Storage
7 - Data Storage

We are using Windows version of Sisense.. In one of our pivot tables, we have added an extra column as a 'spillover' for cases when text for said column exceeds the maximum character limit.  Say we have 70,000 characters in a column and the limit is 64,000(set by Sisense).  We have set the cube up so the additional 6,000 characters will now display in the spillover column. 

My wish though is to hide this spillover column in cases where there is not spillover.. 

Anyone have a script that will hide this spillover column when it is not housing the extra text?

 

snicholls_1-1706114258956.png

 

1 ACCEPTED SOLUTION

snicholls
7 - Data Storage
7 - Data Storage

we ended up going with a different design.  thanks for the offer.

Sam

View solution in original post

2 REPLIES 2

DRay
Community Team Member
Community Team Member

Hello @snicholls,

Thank you for your question. I'm not able to find a way to hide a column like that.

Can you elaborate on the use case? We may be able to offer alternative solutions.

David Raynor (DRay)

snicholls
7 - Data Storage
7 - Data Storage

we ended up going with a different design.  thanks for the offer.

Sam