I have a Table with a couple thousand rows. I right-clicked in the Table and selected Totals Row. Nice feature. There's now a dynamic total that sticks to the last row of the table regardless of what filter criteria I select.
I want to scroll through the rows above the Totals Row, changing filter criteria at times, and always have that total visible. I used the View > Split feature in an attempt to keep the Totals Row visible at the bottom of the window, but sometimes it gets moved while scrolling. I can't get the Freeze Panes feature to help.
Any suggestions?
Bookmarks