Forum Discussion
Pivot Table: Reformatting Columns
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 descrip...
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.
I'm not working, or familiar with Data Model, so it's not currently valid for me, but I'll try to learn a bit about Data Model and see if I can use it.
Thanks.
Thanks.