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

[snicholls]

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?

[DRay]

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.

[snicholls · Accepted solution]

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

Sam