I dont want to set row column value on load

[ASIM TAUSIF KHAN]

I want to load the json data without following initializers.

<e-field name="Amount" format="C0" maximumSignificantDigits="10" minimumSignificantDigits="1" useGrouping="true"></e-field> </e-formatsettings> <e-rows> <e-field name=""></e-field> <e-field name=""></e-field> </e-rows> <e-columns> <e-field name=""></e-field> <e-field name=""></e-field> </e-columns> <e-values> <e-field name="" caption=""></e-field> <e-field name="" caption=""></e-field> </e-values>

[AngelinFaithSheeba PaulvannanRajadurai]

Hi Asim,

Yes, you can render pivot table without rows, columns and values bound from the given data source based on your need by default.  However, you can dynamically add the fields to the row, column, and value axes by using the field list and grouping bar with the fields panel UI. To enable the field list and fields panel UI in the pivot table, please refer the code example below.

Code example:

<ejs-pivotview id="pivotview" width="860" height="300" showGroupingBar="true" showFieldList="true">

       <e-groupingBarSettings showFieldsPanel="true"></e-groupingBarSettings>

</ejs-pivotview>

Meanwhile, we have prepared a sample for your reference.

Sample: https://www.syncfusion.com/downloads/support/directtrac/general/ze/PivotTable2075198574

Screenshot:

Grouping bar with Fields Panel UI

FieldList UI                                                                                                                                                                                                                                           

For more information about the fieldList and groupingbar features, please refer the UG document below.

Field list: https://ej2.syncfusion.com/aspnetcore/documentation/pivot-table/field-list

Grouping bar with Fields Panel: https://ej2.syncfusion.com/aspnetcore/documentation/pivot-table/grouping-bar#show-or-hide-fields-panel

Please let us know if you have any concerns.

Regards,

Angelin Faith Sheeba