XII 篩選OLAP數據，以及一些“持續”改進（一）

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）。

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對話框將它們列出供我從中選擇。

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成員屬性來實現。這里有個截屏，用顏色成員屬性篩選的數據透視表，因此只有銀色的自行車被顯示了。

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%的產品。為了做到這樣，我將應用一個數值篩選到我的數據透視表。

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。

版權聲明：本文內容由網絡用戶投稿，版權歸原作者所有，本站不擁有其著作權，亦不承擔相應法律責任。如果您發現本站中有涉嫌抄襲或描述失實的內容，請聯系我們jiasou666@gmail.com 處理，核實后本網站將在24小時內刪除侵權內容。

版權聲明：本文內容由網絡用戶投稿，版權歸原作者所有，本站不擁有其著作權，亦不承擔相應法律責任。如果您發現本站中有涉嫌抄襲或描述失實的內容，請聯系我們jiasou666@gmail.com 處理，核實后本網站將在24小時內刪除侵權內容。