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

[lhasz]

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?

Index	Name	State	Amount	Units	Total
1	Mickey	GA	$       5.00	1	5
2	Mickey	GA	$       5.20	2	10
3	Mickey	GA	$       7.00	4	20
4	Minnie	GA	$       5.00	8	40
5	Daisy	GA	$       6.99	7	48.93
6	Goofy	FL	$       4.32	9	38.88

[DRay]

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.

[lhasz]

It appears these hide from display but the columns are visible when exporting to csv. 

[DRay]

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.

[DRay]

What is the Index column being used for? Can it removed from the Widget?

If not, please submit a support case for this. They will work with you to find out why the script isn't working when exported.

Thank you, and have a terrific Tuesday!