Is there a way to lock the totals shown at the bottom of a pivot table, similar to the way they are locked and always displayed on a chart? I can get it to total and show as a row, but it is not locked and scrolls within the table.
I think he means more like the "freeze pane" or freeze top row from Excel funcationality. In pivot table, the total "row", placed at the top or the bottom, scrolls with the data.
Is there any way to make it stick to the top or the bottom regardless of the scrolling of the table?
Hi - thank you for the follow-up. We didn't find a solution. We found a work-around where we created a container and created multiple text objects in it, to display the totals. Totally inefficient, but was the best we could do. I'm not sure why it was closed. However, I do welcome any suggestions you may have.
.png "Miguel_Angel_Baeyens"){kind=avatar}
