It seems that GroupUp does not work well in a Choices field.
I have a field with categories. As long as I use it as a text field, grouping up works perfectly and shows the results for 35 categories + 1 Grand Total.
If I use it as a choices field and the database is not sorted by categories in this field, the same analyze procedure delivers the categories obviously not grouped up, they appear many times. In fact, my database now sums up for >2500 categories.
If I sort the categories before grouping (up), then I get my correct 35 categories + 1 Grand Total.
So it seems to me that the “Sort Up” part of the “Group Up” process is failing in choices fields.
The “Automatic” editor mode of a choices field aka “Choices Palette” does not seem to work. I cannot confirm my picked choice with tab or enter, the choices panel remains open. I have to close the data sheet in order to get out of this mode.
I then changed my “categories” field to a text field, because I had to enter some changes.
Very irritating: The Editor Mode remained “Automatic” and continued to display the persistent Choices Palette with the radio buttons.
I think, when the field type is changed from CHOICES to TEXT, Panorama X should switch the Editor Mode from “Automatic” to “Text”, too.