formatting pivot table report
I'm trying to use the "format report" feature with a pivot table but can't
format a field.
I have a field that I dragged into the row area, but it is a dollar amount.
I cannot format the cell as currency. Every time I refresh the pivot table,
it reverts back to no formatting. I know how to change the format/number for
a cell in the data area, but I do not have the same options when it's in the
row area. Is this possible?
|