XII 筛选OLAP数据，以及一些“持续”改进（二）

And now my report is showing only bikes with a profit margin greater than 40%.现在报表只显示利润大于40%的自行车了。(Click to enlarge)I am personally a very big fan of this feature.我个人认为这个功能非常有趣。Hiding levels of hierarchiesExcel 12 PivotTables that are connected to Analysis Services allow you to hide any level of a hierarchy as long as at least one level is still visible. As an example, say I want to compare bikes independent of what type of bike they are (I don’t want to see Category or Subcategory information). To do this, I can hide the parent levels of the product name level. Specifically, I just need to select Show/Hide Levels from the PivotTable context menu, and from there I can toggle on or off any levels I like. 隐藏层次级别连接到Analysis Services的Excel 12数据透视表允许你隐藏任何层次级，只要至少还有一级是可见的就可以。举例说，假如我想比较自行车，不管它们是什么型号（我不要查看Category或Subcategory信息）。要实现这个，我可以隐藏产品名称级别的父级别。确切地说，我只需要从数据透视表的右键菜单中选择显示、隐藏就可以，并且从那里，我可以切换任意级别的开或关。