Complicated Question

Okay folks, this one is complicated, and I apologize in advance….

I am building a report for sales team members to show how their accounts are performing in various product areas - for three time periods (last month, year to date, and prior year to date)
The report has to show sales by account, and then by Item Category. Getting this information is not my problem - it is getting it in a report that works in less than 2 hours per sales person.

Originally I was building the report using an NL(ROWS) command, filters included: salesperson and my time period including both YTD and PRIOR YTD (1/1/2014..2/28/2014|1/1/2013..2/28/2013)
both of these filters were referenced from the OPTIONS page, put at the top of the REPORT page, and then within the REPORT page they were consistently referenced from the top of the page rather than going back to OPTIONS.
The ROWS command was created as a Grouping report - with the first tier being where I retrieved the account codes, second tier retrieved the Item Category codes, and then using SUM commands based on the filters created there.
All info came from the same table (which I understand is a custom table provided for us "ORDER USAGE ENTRY")
Even with not needing to combine tables - this report was taking me 2 hours to run.

So after a lot of digging in the forums (and cursing the need for so complex a report being run through a substandard data line), I decided to re-write the report using the NL(TABLE) command.
This helped quite a bit - data generates quickly - but now I had three separate tables (on different tabs) and these needed to come together into one location.
I decided my best solution was to still use a ROWS command on another sheet to create the actual final version of the report - then use Pivot Tables (generated in Report mode from the NL(TABLEs) and GETPIVOTDATA commands to access the info).
This was great, brought my report down from 2 hours to less than 20 minutes!

However, now I need to complicate it and make the GETPIVOTDATA formulas into NP(EVAL) formulas (so that the final output doesn't rely on those pages after being run through the scheduler) - and here's where it gets weird….
NP(EVAL) isn't calculating the first time I run the report - it only calculates after I've run it once and then run it a second time…. But the Pivot Tables are PRIOR to the Report page I'm trying to work with…

I'm hoping someone has a brilliant idea here :) I'm headed home for the evening - too much for my head for one day.