Hello,
I’m working on a pivot table using a function-backed.
Since Workshop doesn’t provide a built-in way to add a Total row using backed function, I generate it in the function backed. However, unlike with an object-backed, the Total row is treated like any other row. As a result, when I sort the pivot table, the Total row is sorted as well instead of remaining at the bottom.
Has anyone run into this issue before? Is there a recommended approach to keep the Total row fixed at the end, even after sorting?
Thanks for any advice