Get Free Trial

Pivot Table with Chart

Manvi Gupta asked on June 4, 2020

I have the following requirements related to pivot table:

  1. Do font color background color and font size customization of row header, column header sub-total and grand total rows. Is this feasible?
  2. Do integration with Google charts and if data is filtered in pivot table, the change should get reflected instantly in the integrated bar chart/pie-chart/other charts. Is this feasible?
  3. Can we export pivot data along with integrated charts into a pdf and excel format?
  4. Do data filtration based on rows/columns added in pivot table. Is this feasible?

1 answer

Vera Didenko Vera Didenko Flexmonster June 5, 2020

Thank you for your interest in Flexmonster. 

Please see our answers below:

  1. Yes, you can add additional styles to customize Flexmonster’s appearance.
    Here is an example of how the subtotal and grand total, row and column header colors and fonts can be styled using CSS:

    Moreover, it is possible to create your own Flexmonster theme and use it in your project.
    Recently, our team has added a custom theme builder app, making it easier to create your own Flexmonster themes.

    You can add the needed additional styles to the end of the flexmonster.less file, build the custom theme and use the generated CSS files in your project.
    Such an approach allows keeping Flexmonster styles in one place.

  2. Yes, Flexmonster can be integrated with third-party chart libraries, including Google charts. 
    Please see our integration with Google Charts tutorial for guidance.
    As for keeping the integrated chart up-to-date with the Pivot Table, we would like to confirm that this is supported.
    For example, in the following integrated bar chart, when the data is filtered in Flexmonster, the changes will get reflected in the integrated chart as well.

    You are welcome to check out more examples of chart integrations on our website by the following link.

  3. Regarding export, we would like to kindly explain that Flexmonster’s export options don’t get applied to third party charts. 
    For more information about the available export options, please see the following guide:

  4. We would like to confirm that Flexmonster supports a wide range of filters that can be applied to a field. 
    Also, you can set report filters, allowing you to filter the results by fields that are not present on the grid.
    Here is a JSFiddle example for illustration:
    Please let us know if this is what you were looking for.

Please let us know if this helps. If further questions arise, please feel free to reach out.
Kind regards,

Please login or Register to Submit Answer