How to change the row/column header value in PivotGrid?
This KB illustrates that how to change the row/column header value in PivotGrid.
Solution:
You can refer to the following code examples to customize the row header text in PivotGrid control.
JavaScript
$(function () {
$("#PivotGrid1").ejPivotGrid({
url: "../wcf/OLAPService.svc", afterServiceInvoke: "OnChangeRowHeaderText"
});
});
function OnChangeRowHeaderText(args) {
var JsonData = this.getJSONRecords();
if(JsonData[2].Value == "FY 2002")
JsonData[2].Value = “2002”;
this.setJSONRecords(JSON.stringify(JsonData));
}
MVC
@Html.EJ().Olap().PivotGrid("PivotGrid1").Url(Url.Content("~/wcf/PivotGridService.svc")).ClientSideEvents(clientSideEvent => clientSideEvent.AfterServiceInvoke("OnChangeRowHeaderText"))
<script type="text/javascript">
function OnChangeRowHeaderText(args) {
var JsonData = this.getJSONRecords();
if(JsonData[2].Value == "FY 2002")
JsonData[2].Value = “2002”;
this.setJSONRecords(JSON.stringify(JsonData));
}
</script>
ASP
<ej:PivotGrid ID="PivotGrid1" runat="server" Url="../wcf/PivotGridtService.svc">
<ClientSideEvents AfterServiceInvoke="OnChangeRowHeaderText"/>
</ej:PivotGrid>
<script type="text/javascript">
function OnChangeRowHeaderText(args) {
var JsonData = this.getJSONRecords();
if(JsonData[2].Value == "FY 2002")
JsonData[2].Value = “2002”;
this.setJSONRecords(JSON.stringify(JsonData));
}
<script/>
