• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 6. Performing Calculations Withi... > Managing and Maintaining Your Pivot ...

Managing and Maintaining Your Pivot Table Calculations

In your dealings with pivot tables, there will be times when you won't keep a pivot table for more than the time it takes to say, “Copy, Paste Special, Values.” There will be other times, however, when it will be more cost-effective to keep your pivot table and all its functionality intact. When you do find yourself maintaining and managing your pivot table through changing requirements and growing data, you may find need to maintain and manage your calculated fields and calculated items as well.

Editing and Deleting Your Pivot Table Calculations

When your calculation's parameters change or you no longer need your calculated field or calculated item, you can activate the appropriate dialog box to edit or remove the calculation.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint