wps透视表列总计移到顶部_数据透视表运行总计百分比

本文介绍了如何在Excel数据透视表中使用"将值显示为"功能,特别是关注% Running Total In选项,它显示当前运行总计金额除以总数的百分比。通过示例展示了如何设置和解读运行总计百分比,帮助用户更深入地分析数据。

摘要生成于 C知道 ,由 DeepSeek-R1 满血版支持, 前往体验 >

wps透视表列总计移到顶部

At the beginning of every month, I download the previous month's statistics for my web site, to see which pages and files were the most popular. After the data is imported to Excel, I use pivot tables to get a quick overview of the activity.

在每个月初,我都会为我的网站下载上个月的统计信息,以查看最受欢迎的页面和文件。 将数据导入Excel之后,我使用数据透视表来快速了解活动。

If a page is getting lots of hits, I might add a new section to it, to make the content even better. And, seeing which sample files get downloaded most frequently gives me ideas for creating new examples.

如果某个页面的点击量很高,我可能会在页面上添加一个新部分,以使内容更好。 而且,查看下载频率最高的示例文件为我提供了创建新示例的思路。

I'm sure you do something similar for your month end, to see how things are going. And the raw statistics are interesting, but with a pivot table (or 12), you can dig even deeper into the results.

我确定您在月末会做类似的事情,以查看情况如何。 原始统计数据很有趣,但是有了数据透视表(或12),您可以更深入地了解结果。

Use Excel Pivot Table Running Total Percent to Analyze Sales http://www.contextures.com/xlPivot14.html

数据透视表“将值显示为” (Pivot Table "Show Values As")

When you add a number field to a pivot table, it usually shows up in the Values area, summarized by Sum or Count. There are lots of other options though, such as Average, Minimum and Maximum.

当您将数据字段添加到数据透视表时,它通常显示在“值”区域中,并按“总和”或“计数”进行汇总。 但是,还有很多其他选项,例如“平均值”,“最小值”和“最大值”。

Also, there are many ways to view those Sums or Counts. Just right-click a Value field, and click "Show Values As", to see what's available, such as % of Column Total, or Running Total In.

同样,有很多方法可以查看这些总和或计数。 只需右键单击“值”字段,然后单击“将值显示为”,以查看可用的内容,例如列总数的百分比或运行总额

showvaluesas01

总运行百分比 (% Running Total In)

One of my favourite options is the % Running Total calculation, which shows the current running total amount, divided by the grand total. This option was added in Excel 2010.

我最喜欢的选项之一是%总运行额计算,该计算显示当前总运行额除以总计。 此选项已添加到Excel 2010中。

In the pivot table shown below, there are three Value fields in the pivot table, showing the Sum of Qty sold in each month.

在下面显示的数据透视表中,数据透视表中有三个“值”字段,显示每个月售出的数量总和

  • In column C, the sum is shown, with no calculation. This is the number of units sold each month.

    在C列中,显示了总和, 没有计算 。 这是每月售出的商品数量。

  • In column D, the sum is shown, as a Running Total for Date. This is the total units sold, up to and including that month.

    在D列中,总和显示为“日期的运行总计 ”。 这是直到该月(包括该月)的已售出总单位数。

  • In column E, the sum is shown, as % Running Total for Date (new in Excel 2010). This is the total units sold, up to and including that month, divided by the grand total of units sold.

    在E列中,总和显示为日期的运行总计百分比 (Excel 2010中的新增功能)。 这是该月之前(含该月)的总销售量除以总销售量。

By June, a running total of 11426 units have been sold, which is 44% of the overall total units sold. I verified that, buy using a formula in cell G9, to divide the June running total, by the grand total.

截止到6月,已经售出了11426辆,占总销量的44%。 我验证了这一点,即使用G9单元格中的公式进行购买,以将6月运行总计除以总计。

So, sales went better in the second half of the year – the remaining 56% of the sales occurred then.

因此,下半年的销售情况有所好转–剩下的56%发生在那时。

runningtotalpercent01

视频:运行总百分比 (Video: Running Total Percent)

Watch this short video to see how to set up the pivot table, add a running total percent, change the row field and adjust the running total percent.

观看此简短视频,了解如何设置数据透视表,添加运行总计百分比,更改行字段以及调整运行总计百分比。

演示地址

00:00    Introduction 00:19    Create the Pivot Table 01:09    Add Fields to Pivot Table 01:36    Sort by Sales Amount 01:55    Add Running Total Percent 02:44    Read the Running Total Per 03:23    Change the Row Field 04:13    Fix the Running Total Percent 04:31    Running Total Percent by Month 04:59    Get the Sample File

00:00简介00:19创建数据透视表01:09将字段添加到数据透视表01:36按销售额排序01:55添加运行总计百分比02:44读取运行总计百分比03:23更改行字段04: 13固定月份的运行总计百分比04:31每月04:59的运行总计百分比获取示例文件

下载样本文件 (Download the Sample File)

To follow along with the video, you can download the sample file from my Contextures website, on the Pivot Table Running Totals page. The file is in xlsx format, and does not contain macros.

要观看视频,可以从Contextures网站的“数据透视表运行总计”页面上下载示例文件。 该文件为xlsx格式,不包含宏。

Use Excel Pivot Table Running Total Percent to Analyze Sales http://www.contextures.com/xlPivot14.html

翻译自: https://contexturesblog.com/archives/2015/05/07/pivot-table-running-total-percent/

wps透视表列总计移到顶部

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值