Column Group Title Rename in Pivot

[EPM Solutions]

Hello Team,

Is it possible to remove Extra added text (based on the aggregation) on column title for particular column. please let me know the solution, as shown in the below image ,  here I need Only Forcast To complete Instead of sum(Forcast to complete) as column title. Bu t functionality should remain same.

[paramvir]

Yes it's possible to customize colModel ( which includes modify title of some of the columns ) generated during pivoting.

It's documented in these examples:

https://paramquery.com/pro/demos/pivot_custom

https://paramquery.com/pro/demos/pivot_total

[EPM Solutions]

Yes, But here I need it like, it should come under the month 3 column should come and 3rd one(Sum Total) should be total. other Two column should be like as it is.  As shown in the image

[paramvir]

You have to recurse through colModel in pivotCM event ( as shown in previous links ) and remove aggregate name from the titles.

Code: [Select]

col.title = col.title.replace(/\S+\((.*)\)/, "$1")

If you are still facing difficulties, please share a jsfiddle/ plnkr.

[EPM Solutions]

Thank you , I got IT.