Showing cross tabulation row totals

In Cloudera Data Visualization, you can add a totals row to cross tabulation visuals.

  1. Open the Dashboard Designer.
  2. Click Settings in the VISUAL section of the right-side menu bar.
  3. In the VISUAL SETTINGS menu, click Data Summary.
  4. Select the Show row totals option.

    Once selected, the Combine row totals option becomes available. It is valid when there are multiple measures and at least one dimension on the Column shelf.

    In the following example, the first visual shows data without row totals, while the second visual includes row totals.

    You check the Combine row totals option, if there are multiple measures and at least one dimension in the Column shelf.

    In this example, the first visual shows uncombined totals for the Import and Export columns, while the second one combines them to display the actual trade deficit.