Since these reports replace ones containing subtotals, the query will be flagged for replacement when a new BI tool is available. In the meantime, please use the subtotal function in Excel. Additional instructions for creating pivot tables is here.