Create your NL(Table) function
Either use the Table Builder or, if you use the Jet Function Wizard or type or function by hand, be sure to give your table a name by using the special TableName= filter
Run your report
It is important that your report be in Report (not Design) mode for the next step.
Insert the Pivot Table
Select any cell within the Excel table that now contains your data, and then click the PivotTable button on the Insert ribbon.
Ensure that the table listed in the Create PivotTable dialog matches the name you gave to your Excel table in step #1.
Click OK and Excel will insert the Pivot Table from where you will have access to all the data contained in your report.