Simply click 
and
that can be found in
taskbar to switch between table and chart view.
Measures
- To select a measure, click
to switch to pivot table view.
- Tick the checkbox
or leave it unchecked
to select specific measures.
- Having finished selecting, click
to switch back to chart view.
Example: On the image below you can see that only Quantity is selected.
 |
Take care when selecting measures since not all measures give satisfactory results and information across all levels of individual dimension. Example:
Using the Quantity measure (in unit of measure) across all item levels, a chance exists that incompatible data is retrieved ("to compare apples and pears").
|
Setting up Preferences and Tools
For detailed treatment see Preferences and Tools.
Pivot Chart
To generate various analyses, simply drag and drop (using a mouse) individual dimensions from one border to the other. If a certain dimension is not required in the current analysis, eliminate it by dragging it outside the chart area (or, by selecting the region and pressing
). You can have multiple dimensions listed at the same time.
Click
in
taskbar to restore dimensions.
Drilldown
Drilldown can be performd for dimensions currently located at axis x and for those that are at axis y. Drilling down means that you can collapse any dimension member to child attribute items (if they exist) and view detailed data.
To drill down by x axis, double-click any part of chart (e.g. a specific column) or value.
To drill down by y axis, double-click any column any legend entry.
You can remove individual levels (which can be found at the x or y axis) from analysis in the same way as entire dimensions (by pulling them outside the table area or by marking the region and pressing
).
Or, perform drilldown using a pivot table and then switch back
to chart view.
Filter Settings
Filter data by clicking column field and selecting corresponding values. That is, click
icon to set filter. Selection is done in the same way as in the
Parameters panel.
Intersection of Multiple Dimensions
To analyze data by intersection of multiple dimesions, simply follow the procedure desribed under the Pivot Chart section and drag them to the x or y axis borders. Dimensions located together at one border form intersections. Collapse them in a similar way as child items that can be found under Drilldown.
Chart Settings
For detailed treatment see Preferences and Tools.
Rollback Initial Settings
Click
in
taskbar to rollback to pivot chart's initial settings (position of dimensions on borders, sets of preferences...).
| |
Pivot chart is in an interactive way connected with the
pivot table. Changes made to the chart influence table layout, and vice versa. |
PANTHEON Guide:
Related topics: