snicholls
Data Storage
Joined 5 years ago
User Profile
User Widgets
Contributions
In a Pivot Table I need to hide a column when no data present but show column when data is present
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?
