Using the Sum as a Filter

I am trying to write a report that will generate our 1099 information from NAV. The background is that we have all of our companies (40+) within one NAV database company, we use Global Dim 1 as our company code. I created the report to replicate a section for each company, which worked fine. I then need to only pull vendors that have an 1099 amount for the year over $600, this is where I ran into my problem. I found most of the solution here in the community but I have one sticking point.

When the row replicates it does not update the Global Dim cell reference within the Sum filter section because it is text. So while each section replicates it is still using the value in B4 rather than the appropiate cell for that section. I can just create a section for each Dim 1 Value but I wanted be able to use the Dim Value table so maintenace was eliminated.

Any help is very appreciated.


=NL("Rows","Vendor",,"10020 1099 Code","<>''","=NL(""Sum"",""Vendor Ledger Entry"",""10021 1099 Amount"",""Buy-from Vendor No."",NF(,""No.""),""Global Dimension 1 Code"",B4,""Posting Date"",$A$2)","NUMBER&<-600")

Kevin