Properties- Sorting, Data Handling

This topic contains the following sections:

• Sorting

• Data Handling

Sorting

The Sorting tab controls how you order your data (Figure 1) and has a default setting of Auto for both dimensions and measures. You can switch to Custom sorting if you'd like to set your own values and Sort by expression, numerically or alphabetically.

Figure 1: Sorting

Vizlib Pivot Table currently supports YYY, YYYY MMM and MMMM date formats.

Data Handling

Data Handling contains settings relating to the data in the object (Figure 2). You can control the Data downloading limit, Suppress Zero Values, enter a Calculation condition using the editor, and also enter a message to display if the calculation is not fulfilled.

Figure 2: Data Handling