We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy.
Unfortunately, activation email could not send to your email. Please try again.

Pivot Client

Browse multidimensional data organized in the form of dimensions, measures, and KPIs in a cube format, as well as relational data with the pivot client control. You can visualize the results in graphical (pivot chart) and tabular (pivot grid) formats. The control can also be used to create and edit reports on the fly that are stored for later use.


Data Binding

Bind both OLAP and relational data sources.


Browser Compatibility

Our pivot client control is supported in all the major browsers in use today, including:

  • IE 8+
  • Firefox 2.0+
  • Chrome 1+
  • Opera 9+
  • Safari 3.0+

Slice and Dice

Build analysis and decision-making applications in which end users can easily drag elements of their choice to visualize performance, trends, outliers, and more.

Slicing and dicing functionalities in ASP.NET Core pivot client control


Pivot Grid

Display a set of multidimensional and relational data in a concise, precise, and compact area. Rendering of data in tabular format can be easily understood by users of any level.

Pivot grid control view in ASP.NET Core pivot client


Pivot Chart

Pivot chart provides a user-friendly graphical UI. Interactive capabilities allow end users to expand/collapse different levels in a hierarchical dimension.

Pivot chart control view in ASP.NET Core pivot client


Control Placement

The layout of pivot client’s visualization controls can be customized by placing them in either tab or tile view. In tab view, both grid and chart will be displayed in a separate tab, whereas in tile view both grid and chart will be displayed one-over-the-other within the same layout.

Tile View - Custom appearance in ASP.NET Core pivot client control Tab View - Custom appearance in ASP.NET Core pivot client control


Default View

Default view defines the initial layout for the pivot client.

Customizes the default appearance of ASP.NET Core pivot client control


Hide Grid/Chart

Show only the chart or the grid.

Shows/hides grid in ASP.NET Core pivot client control Shows/hides chart in ASP.NET Core pivot client control


Toggle Panel

Collapse the axis element builder and cube dimension browser panel.

Expands/collapses axis element builder in ASP.NET Core pivot client control


Maximized/Full Screen View

Pivot grid and pivot chart can be maximized to full screen mode. Grid and chart will be aligned as per the pivot client layout. You can also perform drill up/down actions in the maximized view.

Maximizes view of grid and chart in ASP.NET Core pivot client control


Label and Value Filtering

Filter members in a hierarchy either by their labels or values.

Filters members by label/value at run-time in ASP.NET Core pivot client control


Filtering by Members

Filtering by members in pivot client provides you the option to check or uncheck the nodes in an editor to filter specific members.

Filters members at run-time in ASP.NET pivot client control


Dynamic Report

Create and update reports on the fly by dragging items from the cube dimension browser to the axis element builder. We can also change the axis of each item by dragging the split button between different axes in the axis element builder.


Toolbar

Perform various operations, such as adding new reports, removing existing reports, renaming existing reports, and saving and loading reports. End users can also view the visualization controls in maximized view, perform Excel export, and more.

Customizes the pivot client control dynamically through toolbar operations


Saving and Loading Reports

Save the current report collection to the database using the toolbar. Load the report collection from the database. While loading back from the database, report names from the report collection will be displayed, allowing the end user to select the desired report with ease.

Saves report in the database in ASP.NET Core pivot client control Loads report from the database in ASP.NET Core pivot client control


Paging

Load and render large amounts of data without any performance constraint through pager.

Paging in ASP.NET Core pivot client control for better performance


Toggle Axis

Toggle axis will swap items between column and row axes, refreshing pivot chart and pivot grid accordingly.

Before toggling dimension, hierarchy, measure, KPI, named sets, calculated members, and calculated measures between axes in ASP.NET Core pivot client control After toggling dimension, hierarchy, measure, KPI, named sets, calculated members, and calculated measures between axes in ASP.NET Core pivot client control


Export

Export the pivot chart and the pivot grid to Excel, Word, and PDF documents.

Exports report to Excel, Word, and PDF in ASP.NET Core pivot client control


Localization

Localization is the process of customizing the user interface (UI) based upon the local culture setting. Using this feature, data can be displayed in a specific language.

Localization support in ASP.NET Core pivot client control


Themes

Switch among different types of predefined themes to view the controls in different formats. Supported themes are flat-azure, flat-azure-dark, flat-lime, flat-lime-dark, flat-saffron, flat-saffron-dark, gradient-azure, gradient-azure-dark, gradient-lime, gradient-lime-dark, gradient-saffron gradient-saffron-dark, Bootstrap, High-Contrast-01, High-Contrast-02, Material and Office-365.

Flat-azure theme in ASP.NET Core pivot client control Flat-azure-dark theme in ASP.NET Core pivot client control Flat-Lime theme in ASP.NET Core pivot client control Flat-Lime-dark theme in ASP.NET Core pivot client control Flat-Saffron theme in ASP.NET Core pivot client control Flat-Saffron-dark theme in ASP.NET Core pivot client control Gradient-Azure theme in ASP.NET Core pivot client control Gradient-Azure-dark theme in ASP.NET Core pivot client control Gradient-Lime theme in ASP.NET Core pivot client control Gradient-Lime-dark theme in ASP.NET Core pivot client control Gradient-Saffron theme in ASP.NET Core pivot client control Gradient-Saffron-dark theme in ASP.NET Core pivot client control Bootstrap theme in ASP.NET Core pivot client control High-Contrast-01 theme in ASP.NET Core pivot client control High-Contrast-02 theme in ASP.NET Core pivot client control Material theme in ASP.NET Core pivot client control office-365 theme in ASP.NET Core pivot client control


Responsive Layout

Craft sites to provide an optimal viewing experience and easy reading. Navigate with a minimum of resizing, panning, and scrolling across a wide range of devices from tablets to desktops. By using this feature, you can achieve an effective view of the pivot client in all devices, including desktops, tablets, and mobiles.

Normal view of ASP.NET Core pivot client control Responsive view of ASP.NET Core pivot client control


You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.