
That makes it easy to see the original values, and the differences, at a single glance.įor information on the other pivot table value settings, use these links on my Contextures site:

When you set up the Difference From calculations, you’ll select from two drop down lists: NOTE: To see all the settings for Show Values As, go to the Show Values As page on my Contextures site. In the pop-up list, the current setting has a check markįor a different view of your pivot table data, you can choose one of the other options, for either setting.įor today’s example, we’ll look at the Show Values setting, and the Difference From option.Point to Summarize Values By or Show Values As.Right-click a number in the Values area.

Here’s how you can see the pivot table value settings: When you make a new pivot table, the fields in the Values area will get these settings automatically:įor example, in this pivot table, the Units field shows a “Sum of” for each region and date. There are more Show Difference examples and tips on my Contextures site. NOTE: The Show Values As settings are also called Custom Calculations. This short video shows the steps to show the difference between values in a pivot table, and there are written steps below the video. Or, see the percent difference in sales for this month and last month. Use this built-in feature instead! With a couple of clicks, you’ll see the difference between sales in East and West regions. You don’t need fancy formulas in a pivot table, if you want to show the difference between values.
