cancel
Showing results for 
Search instead for 
Did you mean: 

How to hide column in data export?

DXC
8 - Cloud Apps
8 - Cloud Apps

I have a pivot table widget, and I am looking for a way to hide a column when downloading this widget as a excel or csv file. Can anyone help me out?

Thank you!

4 REPLIES 4

DRay
Community Team Member
Community Team Member

Hello @DXC.

Thank you for reaching out.

There are several Widget scripts in the Community that can hide columns. Can you test and let us know if they work for you?

https://community.sisense.com/t5/knowledge/hide-a-column-linux-pivot/ta-p/571

https://community.sisense.com/t5/build-analytics/pivot-2-0-hiding-columns-from-the-display/m-p/3607

Thank you.

David Raynor (DRay)

DXC
8 - Cloud Apps
8 - Cloud Apps

Thanks. But these two posts are for hiding from display but not from data export. I would like a way to hide in the data export. 

DRay
Community Team Member
Community Team Member

To make sure I understand, you want the column to show when viewed directly, but automatically hidden when exporting. Is that correct?

David Raynor (DRay)

Ravid_PaldiTeam
9 - Travel Pro
9 - Travel Pro

Hi @DXC 

To the bestd of my knowledge, there is no way to apply cusotmizations on the native Excel/CSV exports  so there is no way to hide a column from thsoe exports. 

 

With the above being said, both our export and pivot/tables plugins  support this option as a built feature and 

From which branch of DXC are you? Perhaps you are from a branch that already uses our plugins and then I'll simply hop on a call to show you how it works. 

Looking forward,
Ravid

Paldi Solutions - Gold Certified Sisense Partner

[email protected]