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:
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: Read More