Any alternate to export subtotal in excel

[Sonashish]

Hello All,

I have one large excel which is containing EmployeeName, Year, Paid Amount. I imported excel and created various tables. Some of the tables has rowtotal and column totals. These tables also has Year filter, so user can filter the date on selected year and accordingly rowtotal and column total updating. But when user export these table to excel, row total and column total is not exporting. I gone thru so many post and articles, and found this feature is not there and hundresred of user voted in uservoice forum.

Is there any solution where I can add custom row with column total (Paid Amount column) the end of report which will be vary depending on Year filter and alsoallow to export in excel as last row?

Thanks

Sona

[parry2k]

@Sonashish Well, I think the best solution is to use Paginated Report for export or use Analyze in Excel and use pivot table in Excel to work with the data. There is no direct export solution as you see it on the screen.