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

Reg.Pivot Grid -Calculation Columns in Rows

Thread ID:





105436 Oct 12,2012 01:06 PM UTC Oct 17,2012 05:31 PM UTC WinForms 3
Tags: PivotGridControl
Asked On October 12, 2012 01:06 PM UTC


I am using the Syncfusion Essential Grid, Excel-like pivot table feature.
I need to use  calculation/summation to display in rows. By default it is  displaying in the columns. Please help to resolve this issue.


Athiram S [Syncfusion]
Replied On October 12, 2012 01:34 PM UTC

Hi Viji,

Thanks for your interest in Syncfusion products.

In pivotGrid ,there is a property named as ShowCalculationsAsColumns. It gets or sets whether the calculations should appear as rows or columns. The default behavior is for the calculations to appear as columns.

But, you can make the calculations to appear as rows by using the code:


Please let me know if you have any concerns.


Athiram S




Replied On October 15, 2012 08:13 AM UTC

I need to display the UI like, the pivot data via drag-and-drop operations to organize the data in a cross-tabulated form.How to set the PivotControl property for the same for windows forms. In the PivotControl, I need to display the FieldList, column lables ,Values like excel pivot table operation for the user to drag & drop according to their choice.
I have noticed in Silverlight there is a Pivot Schema Designer with Pivot Control.How to do the same functionality in Windows forms.
pl. help.


Athiram S [Syncfusion]
Replied On October 17, 2012 05:31 PM UTC

Hi Viji,

Thanks for your update.

You can create a pivot table in grid with  features like:


Data-binding support

Auto-calculation of Total Summary


Grouping support

Customizable Appearance

Support for XML and Binary Serialization

You can refer to the link for further details:


please let me know if you have any concerns.


Athiram S


This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Please sign in to access our forum

This page will automatically be redirected to the sign-in page in 10 seconds.

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