When you format data in a Data Model, the formatting will be replicated in any PivotTable that uses the formatted data within that workbook.
Highlights
- Format data in a Data Model
- Observe currency formatting changes replicated in a PivotTable
- Observe date formatting changes not replicated in a PivotTable