The Grand Total formatting option is available in the Cross Table widget.
By default, the Grand Total formatting options are not visible. Turn the toggle button ON (
) to use the Grand Total formatting options.
The table given below describes different fields present on Sub Total formatting.
Field | Description | Remark |
|---|---|---|
ROW GRAND TOTAL LABEL | It allows you to specify the label of the Grand Total row. | — |
LABEL FONT | It allows you to change the appearance of the Label. |
|
BACKGROUND COLOR | It allows you to change the background color of the label row. | — |
ALIGNMENT | It allows you to change the text alignment of the label row. | You can align the text to Left, Centre, or Right. |
FONT | It allows you to change the appearance of the Grand Total row. |
|
BACKGROUND COLOR | It allows you to change the background color of the Grand Total row. | — |
ALIGNMENT | It allows you to change the text alignment of the Grand Total row. | You can align the text to Left, Centre, or Right. |
To use the Grand Total formatting options, begin with plotting a Cross Table as shown in the figure below.
Now,
- Change the Grand Total Label Text.
- Change the Label Font
- Change the alignment, background color
- Change the font, alignment, background color of the grand total row
The resultant widget is shown below.