Need to suppress a portion of total unsuppressed groups

[ScorpioMCN]

This might sound easy however I'm using a bunch of criteria (incl. a shared subreport value) to determine which items (based on their ABC code and last date counted) get picked for cycle counts in the current week. The report totally works great however being that there are 20 weeks left in the year I don't want them to get 100+ page report with 2,400 items to count this week (should be no more than 150 items per week). I have a formula that figures out there's xx weeks left in the rest of the year however how do I make the group footer suppress 19/20ths of the final results ??

I tried setting up manual running total formulas to count the total picked items only (ie footers that are NOT suppressed) and then take a portion if the running total (separate formula) exceeds total # of items picked / # of weeks) it then is SUPPOSED to supress those group footers. However it ends up suppressing ALL but 4 items...either I have the formulas in the wrong place and/or there is an evaluation that needs to happen first - I have tried a bunch of things to no avail.

I am an advanced user and have checked all prior posts for a similar situation but this one has me really stumped - just got a brain freeze. Any help would be greatly appreciated!

 

[lbass]

In other words, it will not allow you to reference formulas from the report footer in earlier sections.

-LB

 

[ScorpioMCN]

I guess there is no solution then - I will just give me them the full list (although it's a bit overwhelming!) and let them pick and choose which ones they want to count.