Grand Total

Grand Total

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.

  • You can change the text font, its size, and color.
  • You can make the text bold, italic, and underline it.

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.

  • You can change the text font, its size, and color.
  • You can make the text bold, italic, and underline it.

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.


    • Related Articles

    • Total And Sub-Totals

      No table of figures entries was found.h1. 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 ...

    • Total

      The Total formatting option is available in the Table chart. The table given below describes different fields present on Total formatting. Field Description Remark Label It allows you to select the label you want to assign for the Total column. — ...

    • Decimal Place Formatter

      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 ...

    • Percentage Calculations

      For widgets like pie charts and donut charts, it is sometimes required to display the values as a percentage of the share of each section in the total share. For this, Rubiscape provides a Percentage functionality alongside the Aggregation methods to ...

    • Sentiment Colors

      The Sentiment Colors formatting option is available in the Waterfall chart. It allows you to select the colors for the increasing, decreasing, and total values. The table given below describes different fields present for Sentiment Colors formatting. ...