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:

Created:

Updated:

Platform:

Replies:

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

Hi

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.

Regards
Viji 
 

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:

 Pivotgridcontrol.ShowCalculationsAsColumns=false;

Please let me know if you have any concerns.

Regards,

Athiram S

 

 

 


Vijayalakshmi.S
Replied On October 15, 2012 08:13 AM UTC

Hi
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.

Regards
Viji

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

Filters

Grouping support

Customizable Appearance

Support for XML and Binary Serialization


You can refer to the link for further details:

http://help.syncfusion.com/UG/User%20Interface/Windows%20Forms/Grid/default.htm#!documents/41412pivotgrid.htm


please let me know if you have any concerns.


Regards,

Athiram S






CONFIRMATION

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.

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

;