Display month name in column header

[Kulwant]

Hi I am using PivotGrid V2 and binding to local data ( json array ), the data contain a field called CompletedDate ( format 16/4/2022 18:00), what I would like to do is create a pivot grid that contain the month name columns as below, is this possible

		Year: 2022
		Jan	Feb	March	April	May	June	July	Aug	Sep	Oct	Dec
Status	Reviewed	1	4	1	9	33	4	5	26	5	22	33	134
	Awating Review	3	6	6	1	1	1	1	1	1	1	1	23
		4	10	1	1	34	5	6	27	6	23	34	151

 

Thanks

[Neli]

Hi Kulwant,

I would suggest you use the columnHeaderTemplate option and display only the month of the corresponding date. Below is an example:

 <script id="columnTemplate" type="text/x-kendo-template"> 
     # if (member.levelName = 'CompletedDate CompletedDate' && member.levelNum == 1) { #
        # var date = new Date(member.caption) #
        # var month = date.toLocaleString('default', { month: 'long' }); #      
        <em> #: month #</em>
    # } else { #
        #: member.caption #
    # } #
</script>

Here you will find a Dojo example where the template from above is implemented.

I hope this helps.

Regards,
Neli
Progress Telerik