Reg.Pivot Grid -Calculation Columns in Rows

[Vijayalakshmi.S]

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]

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]

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]

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