Hello,
I have a report using the =NL("Table" function and the resulting data is populating a Pivot table. Is there a way to access the data from the result of NL("Table" function? Right now I have a pivot table using the data but I need to perform some unique counts and the Excel 2010 Pivot Table doesn't support this feature. I can solve this by dropping in NL("count" functions but the performance hit is a bit too much since these functions need to link to several tables and filter with slicers.
This report is based on the NAV018 - Accounts Receivable with Details.xlsx sample report.
I'm only trying to add the breakdown for the aging terms: http://is.gd/P6A6NE
Thanks
Date
Votes
2 comments
-
Jet Reports Historic Posts You cannot pass the results of a Pivot Table generated via NL("table") to an NL("Count") function because the pivot table is generated and updated AFTER Jet Essentials finishes running.
Since you want to be able to use Slicers, you might try using "+Dashboard" in conjunction with NP("slicer") to pass the filter criteria directly into an NL("CountUnique") function that executes at the same time as NL("table")
For more information about Dashboard mode, check out: http://fast.wistia.net/embed/iframe/80gq5gf8gu?autoPlay=true&controlsVisibleOnLoad=true&popover=true&version=v1&videoHeight=450&videoWidth=800&volumeControl=true -
Jet Reports Historic Posts If you want to combine an NL count with NL table try this:
http://community.jetreports.com/viewtopic.php?f=7&t=2175&start=0&st=0&sk=t&sd=a
I had to tinker with the syntax of the code a bit in the above post. Here is what worked for me
=NL("Table","Dimension Value",{"Code";"Dimension Code";"Formula (NL(""Count"",""Dimension Value"",,""Code"",[@],""Dimension Code"",[@[Dimension Code]]))"},"Dimension Code","DEPARTMENT") You can see I am grabbing the fields Code and Dimension Code from the table and including a calculated field ( the NL Count) as a third field.
Please sign in to leave a comment.