Thank you for your reply. I have to admit that I was not thorough enough! It was actually a pivot table where I tried to get the functionality, because when you have a straight table and selects the totals on last row - it is actually standard behavior that the bottom row is frozen. Do you know if the same behavior is possible within a pivot?
Hi Sunny. Sure thing. Top is default, but the customer needs it in the bottom. But as I stated to Marcus above, the functionality actually works for a straight table. I need the same for the grand total (1st dimension) for a pivot table.
I think it won't be configurable within a pivot - the total are at the top or bottom but they will react with the scrolling. A quite ugly workaround could be to overlap your pivot with a second specially adjusted table-chart or maybe using a container for a similar view.
Hi Marcus. That was also my conclusion. Actually I think that your proposed workaround is okay. It could be a container in a container so-to-speak to get a grid and make sure that the objects are above each other. Turn of the totals in the top object and just display one total in the bottom one. On the downside there will be double maintenance but it seems manageable. Thank you for your reply and time 🙂