How to customize the format of date type filed for grandTotal row?

Dear Team,
 
Thanks for the support!
Below is basic info and how-reproduce steps for the issue,hope it's helpful.
And also attached the flat form report.json for your reference.
Basic information:
Pivot View:
datasouceType: elasticsearch
I added a context menu named “To Flat Form” for pivot view value cells, below is what will happen when click this context menu:
1). Build a query json(same as Drill through),we can use this query json to fetch drill through raw-records from elasticsearch via a backend service.
2). Fetch raw data from Elasticsearch, then try to build a new Report Object with the returned raw data, at this moment, will change the datasouceType from elastichsearch to “json”, add “data” attribute in the dataSource object, the other attributes of the target report are the same as original(pivot view).
3). During build the target Report Object in Step 2), I will add “type” and “format” attributes for report.dataSource.mapping[field] object, in this case, for date type field, I add “type:’datetime’,format:’dd/MM/yyyy’.
4).The result of the target report will shows grandTotal and other rows with different datetime format.

Dear Team,
 
Thanks for the support!
Below is basic info and how-reproduce steps for the issue,hope it's helpful.
And also attached the flat form report.json for your reference.
Basic information:
Pivot View:
datasouceType: elasticsearch
I added a context menu named “To Flat Form” for pivot view value cells, below is what will happen when click this context menu:
1). Build a query json(same as Drill through),we can use this query json to fetch drill through raw-records from elasticsearch via a backend service.
2). Fetch raw data from Elasticsearch, then try to build a new Report Object with the returned raw data, at this moment, will change the datasouceType from elastichsearch to “json”, add “data” attribute in the dataSource object, the other attributes of the target report are the same as original(pivot view).
3). During build the target Report Object in Step 2), I will add “type” and “format” attributes for report.dataSource.mapping[field] object, in this case, for date type field, I add “type:’datetime’,format:’dd/MM/yyyy’.
4).The result of the target report will shows grandTotal and other rows with different datetime format.

Dear Team,
 
Thanks for the suggestion ant it's very helpful when there is only one date type field or all date type fields are with a same format pattern.
 
However, if there are multiple date type fields and one is set to "dd/MM/yyyy" and the others set to "dd/MM/yyy HH:mm:ss",use options.dateTimePattern it will affect all date type fields of total rows,but I want the total date type fields' format keep the same as other rows,is there a better way to achieve this?Thanks!
Please refer to the attached screenshot,thanks again.
 
 
 
 
 

Dear Team,
 
Thanks very much!
We will test this issue once the new version released,thanks for you guys so much! 
 

Thanks Team & we'll test the feature, thanks you guys so much!