Formatting a Table

You can format the tables that appear in various charts. Tables can be plotted standalone like Table and Cross Table, or they accompany other charts (like Sparkline Chart in which they accompany a Line, Area, or Column Chart). The table formatting options are explained below.

Column

The column formatting option is available in widgets like Table, Cross Table, and Sparkline Chart.

Decimal Place Formatter

The decimal place formatter allows you to

Select the number of decimal places to be displayed in a number
Select a unit for the displayed number

This option is available in the following widgets for the following entities.

Table:

Measure Column selected in the Column formatting option
Total formatting option
Sub-total formatting option

Cross Table:

Column Grand Total formatting option
Row Grand Total formatting option
Column Sub Total formatting option
Row Sub Total formatting option
Value formatting option for the selected measuring section

Sparkline:

Column formatting option for the selected measuring section

Notes:

The DECIMAL PLACES formatter and DISPLAY UNIT options appear only for numerical variables.
These options appear when you select a particular variable for the entity. For example, in the case of a Sparkline Chart, if you select a variable like Sales or Quantity as Column variable, these options appear in the Format pane. |

The table given below describes different fields present on the Decimal Place Formatter.

Field	Description	Remark
Decimal Places	It allows you to select the number of decimal places in all the numbers belonging to a selected variable.	By default, Auto is selected. It means that the number of decimal places is the same as that present in the dataset. You can select any number of decimal places up to 15.
Display Unit	It allows you to select the multiples of units in which the value is measured.	By default, None is selected as the Display Unit. None represents that no unit is set for the value. You can select any of the following units Default None Thousand Lakhs Millions Billions Trillions Default indicates that the unit is assigned automatically by parsing the value.

To use the Decimal Place Formatter options, first plot a chart using dimensions and measures from the dataset.
For example, we plot a Table of Maximum of Sales by Category and Segment below.

Now, change the

Decimal places to three (3)
Display unit to Lakhs

The resultant table is shown below. After each value in the Sales (max) column, the letter ' L' indicates Lakh as the display unit. Also, the respective values are rounded off to the nearest number with three decimal places.

Similarly, you can apply the Decimal Place formatter to Column and Row Grand Total, as well as Column & Row Sub Total in a Cross Table chart.
Below is a Cross Table of the Average of Profit by Ship Mode and Region. The value at the bottom-right corner of the table (434.79) is called the Column Grand Total.

Now, change the

Decimal places to four (4)
Display unit to Thousands

The resultant Cross Table is shown below. After each value in the Sales (max) column, the letter ' K' indicates Thousand as the display unit. Also, the respective values are rounded off to the nearest number with four decimal places.

Since Sparkline chart accompanies a column containing numerical variable, you can apply the Decimal Place formatter to it.
Below is a Sparkline chart plotted for Sales per Ship Mode and Order Priority. The Sales(count) is the numerical column to which the decimal place formatter is applied.

Now, change the

Decimal places to four (4)
Display unit to Thousands

The resultant Sparkline Chart is shown below. After each value in the Sales (max) column, the letter ' K' indicates Thousand as the display unit. Also, a zero (0) is added at the end of each value to respect the number of decimal places.

Your Rating:

Table of Contents