Peter,
Thanks for the reply. However I may have neglected to communicate a few points.
My example was perhaps a bit over-simplified. In my actual use case, I have a set of data in which there is one common property (column1) by which I’d like to establish groups. In these groups I have several pieces of data to present. One string (column2), and numerous numbers (column3-columnN). In the example I’ve shrunk this down to one extra column, but in reality there are between 15 and 20 columns to the right of the string.
The data coming in will include a row totaling up each numeric column for each group, and since it’s important that the ‘Totals’ row appear at the bottom of each group, this apparent arbitrary reordering of the data within groups is problematic. Also why, unfortunately, enabling the sortable feature will not solve my problem.
The only thing I’ve noticed is that it doesn’t seem to happen until there are a minimum number of total rows in the source data, but beyond that I can’t identify a pattern.
Thanks for your consideration,
– Brandon
