Category / Section
How to add empty values for fields in data source in PivotGrid (client-side)?
1 min read
This KB illustrates that to add empty values for fields in data source in PivotGrid (client-side).
Solution:
You can add empty values for fields in datasource by using the blank spaces (" ") for the empty values.
The below example illustrates the same for empty values in data source.
JavaScript:
var pivot_dataset = [ { Date: "FY 2005", Product: "Bike", Quantity: 2, State: " " }, { Date: "FY 2005", Product: "Van", Quantity: 3, State: "British Columbia" }, { Date: "FY 2005", Product: "Car", Quantity: 4, State: "Brunswick" }, { Date: "FY 2005", Product: "Bike", Quantity: 3, State: " " }, ] $("#PivotGrid").ejPivotGrid({ dataSource: { data: pivot_dataset, //// } });