format calculated pivot

  1. T

    Format a Calculated Field in Pivot Table

    I need to format a pivot table calculated field to a %. When I right click on the field name and go to field settings the "number" option is not listed as it is on the other fields. I can manually format the whole column but then whenever I refresh the pivot table it reverts back to a #. Is...

Some videos you may like

This Week's Hot Topics