TheInformationLab
Grand total Not exporting to Excel
Hi Grand total which is part of Viz is not exporting to the Excel. Any help would be greatly appreciated
Grand total isn't provided by the summary data in Tableau, it would need to be calculated in either the extension code or in Excel. In my view I think this should be in Excel.
In which case are you actually asking for there to be a check box next to a numeric field in the config screen to add a row at the end of the dataset which adds a SUM( ... ) formula? If so this would only really be possible for grand totals, not totals for each pane
@craigbloodworth thanks for your reply. This is great work sir. yes probably a check may be include grand totals? people would be fine with straight sums but for calculated fields like %'s or Distinct counts there might be some work on the user end where its not straight Sum(...) of the field. where they need to figure out the GT's manually. Kudos to you this is very useful extension where people face lot of issues in download to excel.