Examples

We often use JSFiddle.net to provide live examples of our pivot table component. JSFiddle is a free development environment that allows editing and execution of HTML, JavaScript and CSS. With the help of this tool, we have added more than 300 fiddles demonstrating our functionality: from API calls to integration with charting libraries. All examples are divided into categories. Please have a look at the categories menu on the left side. If you are not sure which category is needed just scroll down and look through the titles.

Check out more than 300 samples
Embedding Flexmonster

Flexmonster is embedded via new Flexmonster() API call. In this section, you can find various examples showing how to embed pivot table. Also, here we added integrations with d3.js, ECharts and Kendo UI Splitter widget.

    Data source

    Our component supports a variety of data sources: CSV, JSON, SQL databases and OLAP cubes. This section demonstrates the connection to each data source either by defining it in the report or using API calls.

      Slice configuration

      Define which data is shown in your reports: add rows, columns, measures, and report filters. Learn how to configure sorting and different types of filtering, expand values, and many more in this section.

        Conditional formatting

        Flexmonster pivot table allows highlighting cells depending on their values. Conditional formatting is available both via API or via the user interface. This section shows how to configure conditional rules in our component.

          Number formatting

          Numeric values can easily be formatted in Flexmonster. This section shows how to set currency symbol, precision, thousand and decimal separators.

            Options

            With the help of options, it is possible to configure which functionality is available for the end users as well as the appearance of Flexmonster Pivot Table.

              Calculated measures

              Our pivot table allows creating calculated values which can be saved within the report and later be opened again. Calculated values can be added via UI, whereas this section shows how they are defined in the code.

                Configuring report

                This section demonstrates various ways to define a report in Flexmonster. Each report contains information about the data and how it will be visualized.

                  Customize cells

                  Flexmonster provides customizeCell function which can modify each cell in the table during rendering. Below are the most common use cases of grid customization.

                    Customizing toolbar

                    Our pivot table comes with a Toolbar that provides access to the main functionality. This section shows different ways to modify the current Toolbar by adding or removing tabs.

                      Demos

                      All demos from our Demos section are gathered below. Find different data sources, color schemas and views.

                        Custom CSS

                        Configure the look and feel of Flexmonster Pivot Table by adding custom CSS styles. Everything can be customized: from font sizes to chart colors.

                          Highcharts

                          See the data from a new perspective by integrating Flexmonster with Highcharts library. Below is the list of Highcharts types supported in Flexmonster by default.

                            FusionCharts

                            Get even more from data visualization by integrating with FusionCharts. Check out all supported FusionCharts types in the examples below.

                              Google Charts

                              Enhance web reporting experience by integrating with Google Charts. This section shows various Google Charts types integrated with Flexmonster.

                                Events

                                Flexmonster offers a variety of different events. This section shows how they all work and also some interesting use cases.

                                  Export and print

                                  Export our pivot table to Excel, PDF, HTML, image, CSV, or simply print it. Check out the most popular ways to use export in the section below.

                                    Global object

                                    With a global object, Flexmonster can save certain configurations common for all reports. This section demonstrates how global object might be used.

                                      Other

                                      Here are gathered some other interesting use cases.