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

Chapter 6. Performing Calculations Withi... > Rules and Shortcomings of Pivot Tabl...

Rules and Shortcomings of Pivot Table Calculations

Although there is no better way to integrate your calculations into a pivot table than using calculated fields and calculated items, they do come with their own set of drawbacks. It's important you understand what goes on behind the scenes when you use pivot table calculations, and even more important to be aware of the boundaries and limitations of calculated fields and calculated items in order to avoid potential errors in your data analysis.

This section will highlight the rules concerning calculated fields and calculated items that you will most likely encounter when working with pivot table calculations.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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