Hide First Column in Table and/or Pivot when exporting to Excel or CSV
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 |
