Preferences and Tools

Preferences and Tools

Sort

In the Sort box you select between:

- sorting in ascending order: and

- soring in descending order:

You can sort both the alphabetic (naems of dimension members) as well as numerical data.

Before clicking the button with which you trigger sorting, it is necessary that you click any cell from the column you want to sort.

You can also sort "manually": drag any optional member and drop it at the designated location.

Limitation

Here you can choose whether you want to display for the column you selected by clicking the cell:

• all lines,
• only the "largest" lines, or
• only the "smallest" lines,

You can do this according to the selection that can be observed in the bottom window.

Totals

In the Totals box you can decide whether you want to display totals or not.

You can display totals by all maximized dimension members that are currently placed on the line and column borders. You can also view only the lines totals or only the columns totals.

Index

In the Index box you can confirm the Show Index checkbox enabling you to view them.

The index is calculated according to the following formula:

Then you have the following two options to select from

- Second/first and

- First/second.

In first case the dimension member, which is deeper down the hierarchical tree structure, appears in the index counter formula (see Filter Settings in Pivot Table topic). In the position of the denominator appears the member that is higher up the hierarchical tree structure.

In the second case you have the opposite situation.

Displaying index is possible exclusively for any 2 members of any dimension (parameters). In case when two members of a single dimension lying on column borders are not selected the following message appears after checking the Show Index checkbox:

The procedure of selecting dimension members is described in the Filter Settings under Creating ZEUS Analyses - Table.

Saving analyses including used indexes is due to technical requirements done according to the procedure as described in the Storing ZEUS Analysis topic.

Opening a stored analysis including used indexes is due to technical requirements done according to the procedure as described in the Opening Stored ZEUS Analyses

Chart

If the Show key checkbox is confirmed (  ) it displays the legend.

If the Show borders checkbox is checked it displays borders.

Select the desired type of chart from the Chart type box.

The following types are available:

• Area
• Bar
• Column
• Line
• Pie
• Stacked area
• Stacked bar
• Stacked column

as they are presented in the  Preferences topic.

Instructions for use:

• Creating ZEUS Analysis - Table
• Creating ZEUS Analysis - Chart
• ZEUS Analyses

Related topics:

• ZEUS Analyses