I'm not sure how easy this is to remedy or if this is an "export to Excel" bug, but in SSRS, the total is calculated on the fly (expansion/collapse) and I think it's done via a hidden XML column, but nonetheless...can the row in the "Excel - Expanded View.jpg" be removed/hidden when exported to Excel? I've tried row visibility and column visibility, ad nauseum. Maybe there's some easy trick I haven't tried yet. Thanks in advance!