lhasz
Data Storage
Joined 2 years ago
User Profile
User Widgets
Contributions
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.881.5KViews0likes4Comments