Woring with Spreadsheets-FILTERI

To filter a preadsheet,right-click and select Show Auto Filter.A icon appears to the right of each column title.Click than icon,and all of the available choices in that spreadsheet column appear in a drop-down list.Select one of those choices,and only the items connected to that choices appear in the spreadsheet.
鼠标右键点击选择Show Auto Filter进行表格过滤。在每一列列名右侧出现一个漏斗形的图标，点击这个漏斗形的图标，出现一个下拉列表包含该列的所有选项，选择其中一个选项，电子表格中只显示与该选项相关的项。
For example,if you wanted to filter on the Trade Type column of a spreadsheet that dispalyed FX Fwd,FX Spot and FX Swap trades,click the symbol for that column,and you would be given three choices with which to filter:FX Fwd,FX Spot and FX Swap.If you selected FX Swap ,only those spreadsheet items that concerned FX Swaps would appear in the spreadsheet.
例如，你想过滤表格中trade列，该列有FX Fwd和FX Spot 和 FX Swap 三种选项，点击漏斗形图标，你会看到一个包含FX Fwd和FX Spot 和 FX Swap的下拉列表。如果你选择FX Swap，表格将只展示包含FX Swaps的记录。

To group the spreadsheet by column groups,right-click and select Show Group by.A Group by area is displayed above the spreadsheet.Once it is enalbed,you can drag columns to the Group by area,and the speadsheet will be grouped by these columns.
鼠标右键点击选择Show Group by，可以按列队电子表格进行分组。分组区域展示在电子表格的上部。一旦分组可用，拖拽列到分组区域，电子表格就可以按照这些列进行分组。

If you have summary calculations set on some spreadsheet columns and you group by some other columns,the summary descriptions are,by default,added to the Goup by row description.You can now specify which of the summary calculations(if any )shoud be included int this description test.Once the data in the spreadsheet has been grouped by a column,the context menu features the Layout > Select Summaries in Group by... option. This option lists all available summaries that have been enabled on the spreadsheet and allows you to specify the ones to be included in the Group By row description.
For example,add Sum summary for the Notional column in the Trade Blotter(for details on using the summary function,see Using the Summary Funciton)

如果您在一些电子表格列上设置了汇总计算，并按其他列分组，那么默认情况下，汇总描述将按行描述添加到Goup中。现在可以指定应该包括哪些摘要计算(如果有的话)
一旦电子表格按某列分组，