|
  
|
||
|
|
||
Using the Pivot, you can turn a large amount of data into a compact report with easily manageable results
.
But what makes it the powerful tool is that you can perform a visual modeling of the report’s structure by manually rearranging fields across different areas or within a particular zone or by hiding them in the customization form. Dragging a field or a group of fields around in the view will result in changing a report on the fly.
You can quickly change orientation of the field from column to row, line up fields in a particular header area, so the values of those fields are arranged in the related area into a hierarchical tree. Thus the logically related data can be organized by categories. Having that tree in your report, you can drill down and up data at different levels. As a result, you perform a deeper data analysis or avoid unnecessary details.
Subtotaling is another way of arranging and summarizing data.
To narrow down the report's results, you can use filters. Filters can be applied at three levels.
First, you can use the prefilter panel. This will affect the entire report.
Second, you can drop field onto the filter header area and uncheck values in the field’s drop-down list to be filtered out. This will affect the entire report too.
Third, you can filter values of the fields located in areas other than the filter header area areas. Only the unselected items of those fields will be hidden in the view but not involved into the calculations.
