...
Filters are added to a table in the same way as they are to a chart, please refer to section for more information.
Table Sorting
...
Show Dimension Sub Total Break - this allows you to add a sub total at each break in dimension value. For example, if the dimension contains a list of Regions and you want to see how much money each region generates, applying a ‘Dimension Sub Total Break’ will display a sub total each time the region changes.
Measures
...
Display column as HTML - If you embed HTML tags within the definition of the data object, and this option is ticked, then that HTML will be applied in the data table; for example, to display an image or to force certain items to display in bold or a different colour.
Show brackets for negative values - Negative values in the column in question will be displayed as (45.68) instead of -45.68. If you add prefixes to your numbers, e.g. currency symbols, the currency symbol will be displayed instead the brackets - (£50)
Percent Ratio/Width - By default all columns will be ‘100’ meaning that they are of equal width. If you make one of the columns ‘50’ it will display at half the width of the ‘100’ columns, if you make another column ‘200’ it will display at twice the width. The numbers don’t need to add up to 100! . For example, if you make changes, like the ones shown in the following screenshot, to the column width the changes will be reflected in the exported file
| Info |
|---|
When the Percent Ratio/ Width has been set for a table, these settings will be honoured when a table is exported to Word or PowerPoint. |
Data Table Total types
On data table Dimensions you can change the Column Total Type. ‘Not Selected’ is the default value but you will be able to choose from By Count or By Distinct.
...
If you’re using a Crosstab table, you will also have the option of entering a new title for Row totals.
...
| Elementor macro | ||||||
|---|---|---|---|---|---|---|
| ||||||