Pivot Table Data Crunching

flysun2082

最近就是要学透视表，太谢谢了

livewire

樓主辛苦了。是PDF格式的文件嗎？

livewire

under learning:

Data Area:

drop here would be things you would want to measure or calculate.

Row Area: unique value

drop here are things you want to group and categorizefor example, Products, Names, and Locations.

Column Area:

drop here are things you want to trend or show side by sidefor example, Months, Periods, and Years.

Page Area:  filter

drop here are things you would want to isolate and focus onfor example, Regions, Line of Business, and Employees.

Pivot Tables Behind the Scenes

When you initiate the creation of a pivot table report, Excel takes a snapshot of your dataset and stores it in a pivot cache. A pivot cache is nothing more than a special memory sub-system in which your data source is duplicated for quick access. Although the pivot cache is not a physical object that you can see, you can think of it as a container that stores the snapshot of the data source

[此贴子已经被作者于2008-10-15 13:16:55编辑过]

easter2006

很好很强大，看了下，貌似是05年的帖子了。好不容易下载完了，很不错的一本电子书。再次感谢lz

ultraboy85

为什么第25个文件只有88kb而已？那位大大可以重新上传吗？

slyvie

  哈哈,太好了! 我下得手都酸了,但这么好的东西怎么不顶一下呢!! 严重感谢楼主的无私奉献!

slyvie

  解压不了,难道哪儿下错了? 白忙活了! 重来!

虫草花

我也解压不了啊。

xiaqi01

我也解压不了，是怎么回事呢？总是提示：You need to have this following volume existed to continue.很奇怪啊，请解压成功的人指点一下啊，谢谢！

dlr98

怎么解压呀