Show subtotal and Grand total in first row
In the classic Form Grid, Grand total and subtotal is shown as last column, but we need it as a first row of the grid.
Thank you for posting your question.
Kindly note that currently, it is only possible to display the totals on the right of all the columns.
Please let us know if you have any other questions we can help you with.
But ,when there is a large data,we need to scroll so long time to see grandTotal
We understand your concerns on this point, still, we do not have plans to introduce this feature. It is because of the current complex architecture responsible for rendering the grid.
However, we have come up with a workaround that may be useful for analyzing grand totals on large tables without the need to scroll over thousands of rows: https://jsfiddle.net/flexmonster/5arusLwg/. It allows automatically scrolling the table to the rows’ and columns’ grand totals. After scrolling to grand totals, the user is proposed to return to the initial position.
The sample uses the scrollToColumn and scrollToRow API calls provided by Flexmonster. It memories the initial position before navigating to the last row/column.
Please let us know if this workaround works for your case.
Looking forward to hearing the feedback.
We are wondering if the proposed solution works for you.
Looking forward to your reply.
We are reaching out to ask if you had some time to check the provided approach.
Please let us know if additional questions arise on this point.