Page 1 of 1

Dates in pivot table

Posted: Thu Nov 25, 2021 12:12 pm
by kevdflan
Good afternoon,

Is there a way to show the full date in a pivot table, I have tried formatting the date but I can only get it to show the year when I need it to show dd.mm.yyyy?

Re: Dates in pivot table

Posted: Thu Nov 25, 2021 2:17 pm
by Max Shamanov
Hello,

Please send us a sample report with test data that reproduces issues for analysis.

Thank you.

Re: Dates in pivot table

Posted: Fri Nov 26, 2021 3:53 pm
by kevdflan
Hello,

Here is the mrt file.

Re: Dates in pivot table

Posted: Mon Nov 29, 2021 6:27 am
by Max Shamanov
Hello,

Please send us test data for your report.

Thank you.

Re: Dates in pivot table

Posted: Mon Nov 29, 2021 9:09 am
by kevdflan
Good morning,

I sent the mrt file on Friday, is this not what you need?

Re: Dates in pivot table

Posted: Mon Nov 29, 2021 1:00 pm
by Max Shamanov
Hello,

In your report template, data is registered as Dataset. It is not saved in the report template. Send us, file with test data(XML, JSON, Excel and etc) or embed all data to resources

Thank you.

Re: Dates in pivot table

Posted: Wed Dec 15, 2021 10:03 am
by kevdflan
Good morning,

Here is the CSV files that you have requested.

Re: Dates in pivot table

Posted: Wed Dec 15, 2021 12:10 pm
by Max Shamanov
Hello,

Sorry, it is impossible to use DateTime values in the summary of the Pivot Table.

Thank you.