Demo report "Invoice List Summary" demonstrates how you can use an external macro to add a pivot table to your report.




The demo macro creates a new sheet "Pivot Table" and builds the pivot table using the data from the "Invoice Summary" sheet.



Here's the macro