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

how Show subtotals for each group by

Venkata jaya prakash asked on January 2, 2020

Hi team,
As showed the below image ,In the table data should be grouped by a value and an in that group by the integer columns summation should be displayed for each group by . 


3 answers

Illia Yatsyshyn Illia Yatsyshyn Flexmonster January 3, 2020

Thank you for reaching out to us.
We would like to kindly inform you that such a feature is not implemented in the current version of Flexmonster.
However, our team suggests using a workaround implemented within an example we prepared for you.
The main approach is to create several instances of Flexmonster and adjust appropriate filters in order to achieve the desired structure. The titles above each block can be created using the title property of the grid object.
Please let us know if it works for you.

Satyanarayana January 6, 2020

Hi Illia, 
Thanks for your response.
We also need to export the data to excel, pdf and csv the above example has columns for each filter section.
And also if we have more number of columns in rows ( slice) say 15 , the grid is formattig to compact form.

Illia Yatsyshyn Illia Yatsyshyn Flexmonster January 6, 2020

Thank you for your feedback.
In case the export from all instances is required, we recommend using the following approach:

  1. Get the data sets from each instance without saving. It is achievable through setting the destinationType property of the params parameter to plain.
  2. The component’s content will be returned with callbackHandler, where it can be transmitted to the method that would combine all data set into the single one.
  3. Adjust the custom saving of the received data.

Please check out an example demonstrating such an approach in order to implement the CSV export.
The classic form is being switched to compact form when there is not enough space left for the scrollable content on the grid.
To avoid the automatic switching to the compact form, we recommend trying the following steps:

  1. Increase the size of the HTML container for the pivot table component.
  2. Resize some columns on the frozen area to leave more space for the scrollable area.
  3. Decrease the number of fields in the slice.
  4. Use the component in the full-screen mode.

We hope it works for you.

Please login or Register to Submit Answer