发布信息

XII 筛选OLAP数据,以及一些“持续”改进(一)

作者:admin      2024-01-10 20:00:33     0



XII 筛选OLAP数据,以及一些“持续”改进(一)

译者:hxhgxy 来源:http://blogs.msdn.com/excel 发表于:2006年7月7日

PivotTables 12: Filtering OLAP data, and some “persistence” improvements 数据透视表 12:筛选OLAP数据,以及一些“持续”改进

In a previous post I covered the new sorting and filtering capabilities of Excel 12 PivotTables. Those features are available for any PivotTable, regardless of the data source. There are a few additional filtering options available for PivotTables connected to Analysis Services, so I want to review those today. I also wanted to make a short point about some “formatting persistence” work we have done in Excel 12. 在前面的文章中,我讲过了Excel 12数据透视表的新排序和筛选功能。这些功能可为任何数据透视表所用,不管是什么数据源。连接到Analysis Services的数据透视表还有一些额外的筛选选项,因此今天我想要回顾一下这些。我也想要简短地看一下我们在Excel 12里所作的“格式持续性”的工作。

Filtering by member properties A few days ago I wrote about member properties. When a PivotTable is connected to data from Analysis Services, you can filter items in the PivotTable based on the value of that item’s member properties. Let’s look at an example. In the screenshot below, I have a PivotTable with Product Categories, Products, and Sales Amounts. I might want to filter the Products in the PivotTable by one of their properties. I can do this by applying a Label Filter … I simply need to right-click on one of the products and choose Filter|Label Filer from the context menu. 筛选成员属性 几天前,我写了关于成员属性的一些东西。当数据透视表从Analysis Services连接到数据时,你可以基于那些项目的属性值筛选项目。我们来看一个示例。在下面的截屏中,我有一个数据透视表,有Product Categories(产品品类), Products(产品)和Sales Amounts(销售数量)。我可能想要通过它们的某个属性在数据透视表里筛选Products。我可以通过申请一个Label Filter实现它……我只是简单地在某个产品上单击右键,并且从快捷菜单上选择Filter | Label Filter(译者,原文误为Filer)。

(Click to enlarge)

This brings up the Label Filter dialog. Since there are member properties defined for the field I selected, the Label Filter dialog lists those for me to select from. 这会打开Label Filter对话框。因为我所选择的字段已经定义了很多成员属性,Label Filter对话框将它们列出供我从中选择。

(Click to enlarge)

If I pick the field name (“Product Name” in the example), the filter will be applied to the visible items in the PivotTable. If I pick one of the member properties, however, which are listed under the field name in the drop down, the filter will look at the member-property values instead. If I only want to see the bikes where the color is silver, I can use the Colour member property to do that. Here is a screenshot of the PivotTable filtered by the color member property so only silver bikes are displayed. 如果选择字段名称(本例中是“Product Name”),该筛选就会应用数据透视表中可见的项目。然而,如果我选择了某个列在字段名称下面下拉框里的成员属性,筛选器就会只关注该成员属性值。如果我只想看看银色的自行车的话,那么我可以使用Colour成员属性来实现。这里有个截屏,用颜色成员属性筛选的数据透视表,因此只有银色的自行车被显示了。

(Click to enlarge)

Filtering by values not displayed in the PivotTable Another filter ability specific to PivotTables connected to Analysis Server is the ability to filter items by a value that is not currently displayed in the PivotTable. For example, you might want to filter products in a sales report by the profit margin of each product, even though profit is not showing in the PivotTable. Again, let’s walk through an example. Below is a PivotTable that shows Sales Amount by Product and Product Category. In this case, I only want to see products that have a profit margin which is greater than 40%. To do this I’ll apply a value filter to my PivotTable. 筛选没有显示在数据透视表里的数值 连接到Analysis Server的数据透视表的另外一个筛选功能是筛选当前并没有显示在该数据透视表里的数值。例如,你可能想要在一个销售报表中,通过每个产品的利润来筛选产品,尽管利润没有显示在该数据透视表里。同样,我们来看一个例子。下面是个按产品和产品品类显示销售量的数据透视表。在本示例中,我仅想要查看利润超过40%的产品。为了做到这样,我将应用一个数值筛选到我的数据透视表。

(Click to enlarge)

After I select Value Filter from the context menu, I see the Value Filter dialog. When I drop the first drop-down, all the different value fields available are listed, even though the PivotTable only contains Sales Amount. I simply select Gross Profit Margin, type in 40, and press OK. 我在快捷菜单中选择Value Filter后,我看到Value Filter对话框。当我拉下第一个下拉列表时,列出了所有可用的不同数值字段,尽管该数据透视表仅包含Sales Amount(销售量)。我只是简单地选择了Gross Profit Margin,输入40,并按下OK。

(Click to enlarge)











图片声明:本站部分配图来自人工智能系统AI生成,觅知网授权图片,PxHere摄影无版权图库。本站只作为美观性配图使用,无任何非法侵犯第三方意图,一切解释权归图片著作权方,本站不承担任何责任。如有恶意碰瓷者,必当奉陪到底严惩不贷!




内容声明:本文中引用的各种信息及资料(包括但不限于文字、数据、图表及超链接等)均来源于该信息及资料的相关主体(包括但不限于公司、媒体、协会等机构)的官方网站或公开发表的信息。部分内容参考包括:(百度百科,百度知道,头条百科,中国民法典,刑法,牛津词典,新华词典,汉语词典,国家院校,科普平台)等数据,内容仅供参考使用,不准确地方联系删除处理!本站为非盈利性质站点,发布内容不收取任何费用也不接任何广告!




免责声明:我们致力于保护作者版权,注重分享,被刊用文章因无法核实真实出处,未能及时与作者取得联系,或有版权异议的,请联系管理员,我们会立即处理,本文部分文字与图片资源来自于网络,部分文章是来自自研大数据AI进行生成,内容摘自(百度百科,百度知道,头条百科,中国民法典,刑法,牛津词典,新华词典,汉语词典,国家院校,科普平台)等数据,内容仅供学习参考,不准确地方联系删除处理!的,若有来源标注错误或侵犯了您的合法权益,请立即通知我们,情况属实,我们会第一时间予以删除,并同时向您表示歉意,谢谢!
关键词: Excel2007

相关内容 查看全部