Hello all: I am trying to create a financial statement from PowerPivot table (which gets its data from an ODBC database) and I'd like to add some manual calculations below the PT. For example, I may want to add back or subtract out certain line items from the Grand Total line and show the results below the PT. However, the PT has a lot of groupings which may be expanded or collapsed at different times, and if a grouping expands it overwrites the data right below the PT. Is it possible through VBA to automatically move these calculations below the expanded PT so that they are not overwritten? If using ordinary PivotTables I could try a Calculated Item so I wouldn't have this issue, but ordinary PTs can't handle the amount of source data (or the fact that the source data had calculations, a fact which isn't in my control at all).

Thank you in advance for any support.