Forum Discussion
Currency Formatting in Pivot Table
Hi there,
I have got a pivot table with currency data in the first column, when ungrouped in the pivot table the currency symbol shows.
When I group the currency in to ranges I lose the currency symbol and can not format it in.
Is there any way to add this in?
Ungrouped
Grouped:
Afraid not. If only with VBA or creating PivotTable based on data model with your own grouping measure.
