There seems to be an arbitrary limit of 5 frozen footer rows. I'd like to have 10 or 20, because I like to do a lot of analysis on the figures, have them in the same table, and follow the columns as I had more time based data.
Seems like an unfortunate arbitrary limit.
I suppose you could create a new table, with the same layout, and when you add data to the first, you expand the analysis table, and drag out the columns and get it to fill. But I'd prefer to do all this in a single table.
Having the analysis not in the footer rows of the source table makes the analysis more complicated because you can't simply refer to entire columns as the analysis results mix in with the source data.