SAP Reports 2011, WIN, INTL, NUL 7090310 用户手册
产品代码
7090310
17.6.1.1 To sort data in the OLAP grid
1.
Right-click the row or column member that you want to sort by.
2.
On the shortcut menu, point to Add First Sort.
3.
From the submenu, select from the available sort options:
•
Ascending
•
Descending
•
Ascending, Break Hierarchies
•
Descending, Break Hierarchies
Note:
An ascending sort on a grid row orders data values from lowest to highest, left to right. An ascending
sort on a column orders data values from lowest to highest, top to bottom.
sort on a column orders data values from lowest to highest, top to bottom.
Search the online help for "Sorting data" in the "Using the OLAP Worksheet" section to learn more
about sorting.
about sorting.
17.6.2 Filtering data in an OLAP grid
Use filters to exclude grid data that are not important, or to display only the data that you want to see.
You can filter grid data by actual values, or you can choose to exclude or display the top or bottom N,
or the top or bottom N%.
You can filter grid data by actual values, or you can choose to exclude or display the top or bottom N,
or the top or bottom N%.
17.6.2.1 To add a filter
1.
Right-click the field whose values you want to filter.
2.
On the shortcut menu, click Add Filter.
3.
In the Define Filter dialog box, use the Filter Type list to specify how you want to filter the data.
You can filter data by "Actual values," or by selecting "Top/bottom n" or "Top/bottom n%."
4.
Use the Filter Definition options to specify which rows or columns you want to exclude or display.
5.
Click OK to add the filter and return to the OLAP grid.
2011-05-16
376
Creating and Updating OLAP Reports