Dec 19 2021 03:58 AM
Hi,
For some reason, Pivot table will not retain the original column's formatting, so you need to do it in the Pivot table anew, which is annoying, but not the main problem.
Here is a description of the problem:
Any help for this annoying issue is appreciated.
Regards.
Dec 19 2021 05:56 AM
If to work with data model PivotTable it's enough to define once in data model both data type and data format, they will be kept.
Not sure about cached PivotTable.
Dec 22 2021 04:50 AM