Table Calculations: Running Total, Percent of Total, Rank & Moving Average

Reading Time: 8 Mins | Level: Beginner to Advanced

1. What are Table Calculations?

Table Calculations are secondary calculations performed on the already aggregated results in the visual cache. They evaluate based on the layout of the table without querying the underlying database!

2. Common Quick Table Calculations

Right-click any Measure on a shelf $ o$ Quick Table Calculation:

1. 1
   Running Total: Cumulative sum over time.
2. 2
   Percent of Total: Proportional percentage contributing to 100%.
3. 3
   Rank: Assigns ordinal rank ($1, 2, 3...$) to categories.
4. 4
   Moving Average: Smooths out trailing fluctuations over $N$ periods.
5. 5
   Year-over-Year Growth: Computes percentage difference from prior period.

3. Addressing & Partitioning (Compute Using)

• Compute Using $ o$ Table (across): Evaluates horizontally across columns.
• Compute Using $ o$ Table (down): Evaluates vertically down rows.