0

NL(Sheets) and Pivot Tables on each sheet

Jet Reports Historic Posts

January 26, 2017 14:55

None

Follow

Hi all,

First post today, so be kind!

I have created a report using NL(Sheets) function. In design mode, the sheet has a pivot table and pivot chart.

When the report runs, it is creating the sheets ok, but the pivot table and chart on each sheet are all referencing back to the original sheet.

What I am aiming for is that the NL(Sheets) creates a new sheet for each of the criteria, with a pivot table and chart summarising the info for that sheet.

I have looked at using Table Builder, but have lots of links in the report headers, using concatenate, finding record links etc, which makes it difficult to use.

Any advice would be much appreciated :)

Thanks

• Facebook
• Twitter
• LinkedIn

2 comments

• 0
  
  Jet Reports Historic Posts January 31, 2017 16:42

  Since a pivot table is tied to either a specific Excel table [by unique name] or to a region of cells [something that is highly challenging when rows are replicated - such as with an NL(Rows) function], I don't know of a way in which you could have a pivot table on a sheet, have that table reference a named Excel table, and then replicate that entire worksheet and force the replicated pivot table to dynamically reference a new (replicated) Excel table.
  
  You could try placing what are now individual sheets into their own workbooks. Likewise, you could run your report and then create the pivot tables.

• 0
  
  Jet Reports Historic Posts February 02, 2017 11:23

  Thanks for your suggestion, I will use the option for now of amended the pivot table range once the report has run.
  
  Thanks