Okay, one step further. Now it's REALLY close! I had one of the formulas in a wrong area.
So it is properly combining the number of records based on >=15 per group, however the "combined" group totals are not adding up together....it appears as if it's taking the first combined group and...
This is amazing!
Thank you soooo much....I feel like it's right there!
I am getting an error on this section:
Then in preview mode, select {table.grp#6field}->right click->format->display string->x+2 and enter:
Whileprintingrecords;
numbervar grpno;
if...
pmax, the Top N almost worked but the N only specified the number of groups before combining, rather than specifying a quantity value from the field that counts the records. So close!
lbass, it is group #6 in the header that I am attempting to combine together. There are definitely 6 individual...
Thank you for the response. Unfortunately it looks as if all that allows me to do is sort the groups by the number of records but does not allow me to aggregate them together based on a number of records.
I am running across an issue that I cannot figure out. Basically, I have 7 grouping levels that have certain suppression criteria, but one of my groups needs to be consolidated based on the number of records found in that group. For instance:
Product----Insurance----State----# Records...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.