如何在Excel中使用数据透视表计算百分比变化

Pivot Tables are an amazing built-in reporting tool in Excel. While typically used to summarize data with totals, you can also use them to calculate the percentage of change between values. Even better: It is simple to do.

数据透视表是Excel中一个了不起的内置报表工具。 虽然通常用于汇总汇总数据，但您也可以使用它们来计算值之间的变化百分比。 更好的是：这很简单。

You could use this technique to do all kinds of things—pretty much anywhere you’d like to see how one value compares to another. In this article, we’re going to use the straightforward example of calculating and displaying the percent by which the total sales value changes month by month.

您可以使用这种技术来做各种各样的事情-您想在任何地方看到一个值如何与另一个值进行比较。 在本文中，我们将使用简单的示例来计算和显示总销售额逐月变化的百分比。

Here’s the sheet we’re going to use.

这是我们要使用的表。

It’s a pretty typical example of a sales sheet that shows the order date, customer name, sales rep, total sales value, and a few other things.

这是一个非常典型的销售表示例，其中显示了订单日期，客户名称，销售代表，总销售价值以及其他一些内容。

To do all this, we’re first going to format our range of values as a table in Excel and we’re then going to create a Pivot Table to make and display our percentage change calculations.

为此，我们首先将值的范围格式化为Excel中的表格，然后创建数据透视表以进行和显示百分比变化计算。

将范围格式化为表格 (Formatting the Range as a Table)

If your data range is not already formatted as a table, we’d encourage you to do so. Data stored in tables have multiple benefits over data in cell ranges of a worksheet, especially when using PivotTables (read more about the benefits of using tables).

如果您的数据范围尚未格式化为表格，建议您这样做。 与工作表的单元格区域中的数据相比，存储在表中的数据具有多种好处，尤其是在使用数据透视表时( 更多有关使用表的好处 )。

To format a range a