This is set of the function to easy summarize and quickly focus on a subset of data without modifying your series and category information to get the report that you need.
- Report Filter
Used if Report Field in Fields List is not empty — each item has own filter. On Screenshot we have one report filter — "Business type" with all fields selected.
- Filter & Sorting
Drop downs to open Filter and Sorting accordion. Filter is an accordion of Members, each with checkbox list. Such list of fields corresponds to set of fields in columns or in rows of the report. By default all elements of the respective field in the report are checked in Filter window. It means, that all data which are accessible on report fields, are shown on the report. But you can filter on each field or a subset of fields on rows and on columns in the Pivot Table report.
- Expanding and Collapsing Totals
With pressing plus or minus buttons
- Drill-Down (OLAP version only)
Operations:
-
Add Report Filter
Show process
Open Fields List, drag field to Report Filter Box, click Update. In top left corner will appear Report Filters, every can be filtered.
- Add Filter
Click on "Row Labels" or "Column Labels" to open Filter accordion, select needed Member and check wanted rows/columns.
- Sort: Click on "Row Labels" or "Column Labels" to open Filter accordion, which consist of Members. It top are sorting buttons
. Press needed button and immediately see report with sorted Members.
- Expanding and Collapsing Totals: simply press cell with plus icon to expand, or with minus one to collapse.
- Drill-Down(OLAP version only): click underlined link in right of totals to see details (it is headed with "+"). To see summary, click this link (now headed with "-") again.