excel数据透视_取消透视Excel数据的快速方法

excel数据透视

Before you can build a flexible pivot table, you might need to rearrange the data. For example, if the data has a separate column for each month’s sales, that won’t work well in a pivot table. You need to “unpivot” your data first. Here’s what that means, and 2 quick ways to unpivot Excel data.

在构建灵活的数据透视表之前，您可能需要重新排列数据。 例如，如果数据在每个月的销售额中都有一个单独的列，则在数据透视表中将无法正常工作。 您需要先“取消透视”数据。 这就是它的意思，还有2种取消Excel数据透视图的快速方法。

Excel仪表板 (Excel Dashboards)

First, a reminder that today, Thursday August 18th, is the last day to register for Mynda Treacy's highly-rated Excel dashboard course. Don't miss out – it well be a few months before the course opens again! You’ll learn how to create awesome dashboards, quickly and efficiently, and you’ll pick up other key Excel skills too.

首先，提醒一下，今天( 8月18日星期四)是Mynda Treacy 备受好评的Excel仪表板课程的最后注册日期。 不要错过-距离课程重新开放还需要几个月的时间！ 您将学习如何快速有效地创建出色的仪表板，并且还将学习其他关键的Excel技能。

枢纽是什么意思？ (What Does Unpivot Mean?)

If your data has a separate column for each month’s sales, it already looks like a pivot table report. Instead of having a separate row for each month’s sales, each row contains 12 months of sales data. It looks good on the worksheet, but won’t work well in a pivot table.

如果您的数据在每个月的销售额中都有单独的列，则该数据看起来已经像是数据透视表报表。 每行包含12个月的销售数据，而不是每个月的销售都有单独的行。 在工作表上看起来不错，但在数据透视表中效果不佳。

When you build a pivot table from that data, there will be 12 different fields with sales amounts – one for each month. The pivot table won’t be able to automatically calculate an annual total. You would have to create a calculated field to add all the month values together.

当您从该数据构建数据透视表时，将有12个不同的字段，这些字段的销售额分别为每月一个。 数据透