3.D. Table Options

Views: Table Options

Table

Here we can customize different options of the table:

  • - If we want the table to be visible.
  • - Size of the page. Useful when there are many records to be displayed. Select a maximum in order not to have too many data on the view that makes it hard for us to analyze the situation clearly. The limit is defined in 300 records per page.

 

table1

Filter

We can define filters to rows / columns through formulas. We have a set of predefined formulas in LITEBI. By selecting the desired formula, in the "tree" at the right side, the parameters that make up that role are shown. Clicking on these parameters we can select any previously set item (measure, calculatedMember, dimensionMember) or new formulas (formula).

table2

Ranking

In the ranking tab we can filter any element of the rows or columns so that that the platform shows us only the number of elements greater or less than we desire. Its an expanded version of what we find in the context menu.

table 3

Order

We can order the table by the parameter that we desire, in ascending or descending.

table 4

Color rules

In the last tab we can apply color rules to the report, according to the desired condition on the parameter we want or to the entire table. We also have available the trend arrows, according to the defined condition.

 

 

table 5