cancel
Showing results for 
Search instead for 
Did you mean: 
intapiuser
Community Team Member
Community Team Member
Sometimes we would like to hide a column in our pivot table so we will be able to apply a specific logic or order the table by a column without displaying it.
The following script will allow you to hide the needed columns in your Pivot table.
To implement it, please make sure to:
  1. Adjust the number of columns according to your widget
  2. Place 0 for the column you'd like to hide
  3. Save the script
  4. Refresh the page
The following script is adjusted for a pivot table with 5 columns, hiding 2 of them:
var newWidth = {
0: 100,
1: 0,
2: 100,
3: 0,
4: 100
}
var columnsToRemove = []
var passed = -1
var wasExecuted = false
widget.on('processresult', function(widget, args){
if (!wasExecuted) {
args.result.metadata.forEach(function(e, index) {
e.panel
if (e.panel != "scope" ) {
index = Object.keys(newWidth).length - index+passed;
if ( typeof(newWidth[index]) !== "undefined" ) {
e["format"] = {"width":newWidth[index]};
}
if (e.format.width === 0) {
columnsToRemove.push(index)
}
}
else {
passed ++
}
})
wasExecuted = true
}
})
widget.on('ready', function() {
columnsToRemove.forEach(function(item) {
var selector = "[class*=table-grid__cell--col-" + item +"]";
$(selector, element).each(function(i, lmnt) {
$(lmnt).text('')
})
})
})
Here is an example of the above script:
Before:
mceclip1.png
After:
Comments
gyanianand
8 - Cloud Apps
8 - Cloud Apps

above code dosent works for me my pivot structure is as below

gyanianand_0-1684134280264.png

 

 

Version history
Last update:
‎03-02-2023 08:28 AM
Updated by:
Contributors
Community Toolbox

Recommended quick links to assist you in optimizing your community experience:

Developers Group:

Product Feedback Forum:

Need additional support?:

Submit a Support Request

The Legal Stuff

Have a question about the Sisense Community?

Email community@sisense.com