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. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback


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

Data Binding

There is extensive support to bind OLAP data sources.

Slice and Dice

Pivot client is great for building analysis and decision-making applications where end users can easily drag and drop elements of their choice to visualize performance, trends, outliers, and more.

Slicing and dicing functionalities in UWP pivot client control

Pivot Grid

Pivot grid is used to display a set of multidimensional data in a concise, precise, and compact area. Rendering of data in the tabular format can be easily understood by users of any level.

Pivot grid control view in UWP pivot client control

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 UWP pivot client control

Key Performance Indicators

KPI are a collection of calculations associated with a measure group that evaluates business success. Typically, these calculations are a combination of multidimensional expressions (MDX) or calculated members. There are four different types of available indicators:

  • KPI Goal
  • KPI Status
  • KPI Trend
  • KPI Value

Key performance indicators, aka KPI support in UWP pivot client control

Calculated Members

Pivot client control displays user-defined dimensions and measures through a UI specially created to define and add dimensions and measures. The calculated members are classified into two types: calculated measure, a user-defined measure element created from an existing measure element; calculated dimension, a user-defined dimension element created from an existing dimension. New calculated members can also be created from existing calculated members, and they can be added to a report through the UI.

Creates user-defined members in UWP pivot client control

Named Set

Named sets simplify MDX queries and provide useful aliases for complex, typically used, set expressions.

Named sets support in UWP pivot client control

Virtual KPI

Users can create their own KPIs at run time and write expressions as well. In an expression, positive numbers will be represented by a green light or up arrow, and negative numbers will be represented by a red light or down arrow, depending on the user preference.

Virtual KPI support in UWP pivot client control

Dynamic Report

Reports can be created and updated on the fly by dragging items from cube dimension browser to 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.

Change report at run time in UWP pivot client control


Pivot client allows users to perform various operations, such as adding new reports, removing existing reports, renaming existing reports, saving and loading reports, and more. End users can also change the chart types, chart palette, exporting, and few other chart options using the icons in the chart toolbar, and change the grid layout, enable tooltip, exporting, and a few other grid options through the icons present in the grid toolbar.

Client toolbar in UWP pivot client control

Report menu in UWP pivot client control

Grid toolbar in UWP pivot client control

Chart toolbar in UWP pivot client control

Report Persistence

Pivot client allows you to store the current session of the report collection in your machine and then load it to the control at a later time.


Paging allows you to load and render a large amount of data without any performance constraint.

Paging support in UWP pivot client control

Pager settings in UWP pivot client control


Localization is the process of customizing the user interface (UI) as locale-specific in order to display regional data. Using this feature, data can be displayed in the specific language and culture of a particular country or region. Visualization of the control right-to-left is also applicable.

Localization support in UWP pivot client control


Transform your applications today by downloading our free evaluation versionDownload Free Trial

Scroll up icon

Warning Icon 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.Close Icon