Table Calculations

Table calculations perform computations on values already in the visualization, computing along table dimensions rather than raw data. They enable running totals, percent of total, moving averages, and ranking without creating permanent fields. Calculations update dynamically as the view structure changes. They're computed after data aggregation occurs.

To create table calculations, perform the following steps.

1. Connect to OrderDate from Kyvos.

2. Drag OrderDate to rows.

3. Drag Sum Sales to text.

4. Right-click the SUM(Sum Sales).

5. Select Quick Table Calculation > Running Total.

   Open

   

6. Drag the sum sales to the text again to compare the sum sales and running totals. The visualization now shows cumulative sales.

   Open