🍉 Meet Flexmonster Pivot Table & Charts 2.9.Check out all the hot features!
Get Free Trial

Show subtotal and Grand total in first row in classic form

Answered
potato asked on April 30, 2021

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.

5 answers

Public
Illia Yatsyshyn Illia Yatsyshyn Flexmonster April 30, 2021

Hi,
 
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. 
 
Best regards,
Illia

Public
potato May 2, 2021

But ,when there is a large  data,we need to scroll so long time  to see grandTotal

Public
Illia Yatsyshyn Illia Yatsyshyn Flexmonster May 3, 2021

Hello,
 
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.

Regards,
Illia

Public
Illia Yatsyshyn Illia Yatsyshyn Flexmonster May 11, 2021

Hello,
 
We are wondering if the proposed solution works for you.
 
Looking forward to your reply.

Regards,
Illia

Public
Illia Yatsyshyn Illia Yatsyshyn Flexmonster May 19, 2021

Hello,
 
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.

Regards,
Illia

Please login or Register to Submit Answer