wps透视表列总计移到顶部_在数据透视表顶部显示总计

wps透视表列总计移到顶部

In a pivot table, you can choose to show or hide the grand totals, but you can't change their position. However, with a quick and easy workaround (no programming required), you can show the grand total at top of  pivot table, for rhe pivot table columns.

在数据透视表中，您可以选择显示或隐藏总计，但不能更改其位置。 但是，通过快速简便的解决方法(无需编程)，您可以在数据透视表的顶部显示总计，以显示数据透视表列。

Here's a screen shot with a Grand Total at the top of a pivot table. It was created with this workaround.

这是在枢纽分析表顶部具有总计的屏幕截图。 它是使用此替代方法创建的。

Unfortunately, there's nothing similar that will create a grand total for rows at the left side of the pivot table.