Forum Discussion

Ocasio27's avatar
Ocasio27
Iron Contributor
Feb 26, 2020
Solved

Edit multiple fields in pivot table

Hello everyone.   I am trying to edit multiple fields in a pivot table, its not possible i keep getting lots of errors. Is there any way I can explore all the data of the pivot table as a table? or...
excel
Formulas and Functions
  • Abiola1's avatar
    Abiola1
    Feb 26, 2020

    Ocasio27 

    You can edit single field in PivotTable  by time

     

    To your second question, You can add leading zeros in PivotTable

    Once you create your report, right-click on the Sum of Total and select Format Cells

    Select Custom and type in the needed number of zeros as see in the caption below

     

     

Resources