Here’s something odd that just happened. Working manually in the Datasheet. Selected records, grouped them in the «Give» field, totaled and did a count in another field.
Then wanted to collapse to the «Give» field, so went to Field>Analyze. There was the RAW DATA and GRAND TOTAL outline levels, but only a blank where GIVE should have been.
But, if I click on the blank, it did collapse to the GIVE outline level.
Here’s a picture (I hope):