Fields container position and default aggregate function

[Shilpa]

Hi team 

 

1. We need boxes to match Microsoft Excel to be as familiar to end users as possible.  Having Rows on top may cause confusion, should be as follows
Filter Fields           Column Fields
Row Fields             Value Fields

2. For values (Aggregate fields) the field settings should be Count by default and not sum. 

 

Thanks in advance

[Shilpa]

Image in reference to point 1

[Shilpa]

Hello team..

 

Waiting for your response

[Pavlina]

Hello,

Unfortunately there is no way to change the container position in the PivotGrid to match Microsoft Excel.

Regarding field setting you need to set Aggregate="Count" for the PivotGridAggregateField in order to change the default value.

Regards,
Pavlina
Telerik