数据透视表 时间汇总月份
It's pivot table time! First, we'll take a look two common problems with time values in pivot tables. Then I'll show you a couple of ways to save time when working with pivot tables.
这是关键的表时间! 首先,我们来看一下数据透视表中时间值的两个常见问题。 然后,我将向您展示几种使用数据透视表节省时间的方法。
数据透视表时间值 (Pivot Table Time Values)
If you're showing time values in a pivot table, here are a couple of things that can go wrong:
如果要在数据透视表中显示时间值,则可能会出错:
- The total times are way too low 总时间太少了
- The times are rounded, and don't show the tenths or hundredths of a second 时间是四舍五入的,不显示十分之一或百分之一秒
There are easy fixes for both of those problems, and the details and a sample file are on the Pivot Table Time Values page on my Contextures site. The quick instructions are below.
这两个问题都有简单的解决方法,详细信息和示例文件位于Contextures网站上的“ 数据透视表时间值”页面上。 快速说明如下。