asked on January 18, 2022
hay there is there an option to declare the grand total row to be fixed to the bottom or sitcky to the bottom ?
or
i see that there is option to put grant total in the top just in flat view and it will be frozen
is that option had in compact view?
thanks a lot
⋅ January 18, 2022
Hi, Dror!
Thank you for raising a ticket.
Currently, there is no option to pin the grand totals to the bottom of a pivot table the way it is shown on the top of a flat form. We suggest developing a workaround using the getData() function to get grand total values.
Please refer to this example of retrieving grand totals with getData():
https://jsfiddle.net/flexmonster/dj0b97y1/
Feel free to contact us if any questions arise.
Best Regards,
Maksym
