Controlling Table Calculations

Build table calculations with more custom control than quick table calculations allow. Create context-sensitive calculations that add more layers of understanding to your data. Explore ways to customize the scope and direction of table calculations, and learn the best way to handle null values. Check out calculations like Percent of Total and Percent Difference From.

Lesson Objectives

At the end of this lesson, you will be able to:

• Describe how to control the scope and direction of a table calculation using the table calculation dialog box.