需要在excel 2007中深入挖掘数据！ [英] need to drill down data in excel 2007!

问题描述

hello-

i在excel表中有6个coulmns ...

hello-
i have 6 coulmns in an excel sheet...

processname  applicationname  month   branch  totalprocess timetaken

aaaa          xyx              4      2013.4    3            20.9
aaaa          xyx              5      2013.5    6            18.3
aaaa          xyx              6      2013.6    7            21.6
xyxavg                                                       20.4

这样我们在报告中有20 -25个进程，这里我只想显示xyxavg行，如果我点击单元格，我想向下钻取所有行..i尝试使用群组功能，但由于我们有25个流程，因此看起来很费时。



有人能帮我找到最简单的方法吗？

like this we have 20 -25 processes in the report,here i would like to display only the xyxavg row,if i click the cell,i would like to drill down all the rows..i tried with group function,but it looks vey time consuming since we are having 25 processes.

can anyone help me to find an easiest way to do this?

推荐答案

您需要做的就是使用过滤 [ ^ ]。

All you need to do is to use Filter[^].

这篇关于需要在excel 2007中深入挖掘数据！的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！