cancel
Showing results for 
Search instead for 
Did you mean: 

Hide First Column in Table and/or Pivot when exporting to Excel or CSV

lhasz
7 - Data Storage
7 - Data Storage

Requirement: Append table to website so that user can view and download to csv. 

Export should be in pivot table format. Export should contain data on individual lines and not grouped. 

Steps to accomplish: Added index column to remove grouping. Now I need help removing the index column when downloading. 

Here is a sample table.

When I export to csv or excel from a pivot I would like to exclude the index column.

Any suggestions?

 

IndexNameStateAmountUnitsTotal
1MickeyGA $       5.0015
2MickeyGA $       5.20210
3MickeyGA $       7.00420
4MinnieGA $       5.00840
5DaisyGA $       6.99748.93
6GoofyFL $       4.32938.88
2 REPLIES 2

DRay
Community Team Member
Community Team Member

Hello @lhasz,

Several Widget scripts in the Community 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)

DRay
Community Team Member
Community Team Member

Hello @lhasz ,

I wanted to follow up to see if the solution offered worked for you.

If so, please click the 'Accept as Solution' button so that other users with the same questions can find the answer faster. If not, please let us know so that we can continue to help.

Thank you.

David Raynor (DRay)