wps透视表列总计移到顶部
Pivot tables are a quick and easy way to summarize a table full of data, without fancy formulas. Occasionally though, things can go wrong. Today we'll figure out why you might see errors in pivot table totals or subtotals, when all the item amounts look fine.
数据透视表是一种快速而简单的方法来汇总一个充满数据的表,而无需花哨的公式。 有时候,事情可能会出错。 今天,我们将弄清楚为什么当所有项目金额都很好时,数据透视表总计或小计中可能会出现错误。
为什么会有错误? (Why Are There Errors?)
Here's a simple pivot table with error values in the Grand Total row.
这是一个简单的数据透视表,其中“总计”行中包含错误值。
It's understandable that the "Average of Price" total shows a #DIV/0! error, because that error also appears for the East region, in that column.
可以理解,“平ASP格”总计显示为#DIV / 0! 错误,因为该错误也出现在该列的东部区域。
But why are there errors in the totals for the Count and Count Numbers columns? There aren't any errors in the amounts that are being totalled there.
但是,为什么“计数”和“计数编号”列的总计中存在错误? 总计金额中没有任何错误。
检查源数据 (Check the Source Data)
Some pivot table mysteries can be solved if you take a look at the source data, so let's start there.
如果您查看源数据,则可以解决一些数据透视表的奥秘,因此让我们从这里开始。
Here's a screen shot of the small table that's the source for the pivot table. You can download this sample file from the Pivot Table Summary Functions page on my Contextures website.
这是小桌子的屏幕截图,小桌子是数据透视表的来源。 您可以从Contextures网站上的“数据透视表摘要功能”页面下载此示例文件。