Dates in pivot table
Dates in pivot table
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?
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?
- Attachments
-
- chrome_bgnvUm9rI4.png (38.48 KiB) Viewed 2285 times
-
- chrome_jB8cIMMi00.png (11.17 KiB) Viewed 2285 times
-
- Posts: 824
- Joined: Tue Sep 07, 2021 10:11 am
Re: Dates in pivot table
Hello,
Please send us a sample report with test data that reproduces issues for analysis.
Thank you.
Please send us a sample report with test data that reproduces issues for analysis.
Thank you.
Re: Dates in pivot table
Hello,
Here is the mrt file.
Here is the mrt file.
- Attachments
-
- Training Matrix.mrt
- (25.34 KiB) Downloaded 173 times
-
- Posts: 824
- Joined: Tue Sep 07, 2021 10:11 am
Re: Dates in pivot table
Hello,
Please send us test data for your report.
Thank you.
Please send us test data for your report.
Thank you.
Re: Dates in pivot table
Good morning,
I sent the mrt file on Friday, is this not what you need?
I sent the mrt file on Friday, is this not what you need?
-
- Posts: 824
- Joined: Tue Sep 07, 2021 10:11 am
Re: Dates in pivot table
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.
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.
- Attachments
-
- Designer_kHthQbGCxX.png (46.16 KiB) Viewed 2188 times
Re: Dates in pivot table
Good morning,
Here is the CSV files that you have requested.
Here is the CSV files that you have requested.
- Attachments
-
- Demox-Employee_Summary.csv
- (7.56 KiB) Downloaded 163 times
-
- Demox-Home_Summary.csv
- (1.14 KiB) Downloaded 163 times
-
- Demox-Employee_Qualification.csv
- (817.93 KiB) Downloaded 162 times
-
- Posts: 824
- Joined: Tue Sep 07, 2021 10:11 am
Re: Dates in pivot table
Hello,
Sorry, it is impossible to use DateTime values in the summary of the Pivot Table.
Thank you.
Sorry, it is impossible to use DateTime values in the summary of the Pivot Table.
Thank you.