Table Calculation Form
Example Data Table
| Partition | Label | Value | Possible Use |
|---|---|---|---|
| East | Jan | 120 | First monthly sales point |
| East | Feb | 180 | Running total comparison |
| West | Mar | 230 | Rank and window analysis |
| West | Apr | 260 | Percent of partition total |
Formula Used
Running Sum: RUNNING_SUM = value1 + value2 + ... + current value
Running Average: RUNNING_AVG = running sum / current index
Percent of Total: % Total = current value / partition total × 100
Difference: Difference = current value - offset value
Percent Difference: % Difference = difference / absolute offset value × 100
Window Sum: WINDOW_SUM = sum of values inside selected row window
Window Average: WINDOW_AVG = window sum / number of window rows
Z Score: Z = (value - partition mean) / partition standard deviation
Percent Rank: Percent Rank = (rank - 1) / (partition size - 1) × 100
How to Use This Calculator
- Paste data in three columns: partition, label, and numeric value.
- Choose the table calculation you want to test.
- Select the order used for addressing rows inside each partition.
- Set offsets for difference and lookup calculations.
- Set window rows before and after for moving calculations.
- Press the calculate button to view results below the header.
- Use CSV or PDF buttons to export the result table.
Table Calculations in Tableau: Complete Guide
What This Calculator Does
Table calculations help you study values after a view has already been grouped. They are useful when raw totals are not enough. This calculator gives a clear way to test those ideas before building a dashboard. You can enter partitioned data, choose an addressing order, and compare many calculation types. It works well for sales, marks, costs, scores, traffic, inventory, and other numeric data.
Why Partitioning Matters
A partition is a separate group of rows. Each group is calculated on its own. For example, East and West regions may each need separate running totals. If both regions were mixed, the result could be misleading. Partitioning keeps comparisons fair. It also matches the way many visual tables separate marks by region, product, class, month, or segment.
Addressing and Sort Order
Addressing decides the row path used by the calculation. A running sum depends on row order. A difference calculation also depends on which row comes before the current row. This tool lets you sort by input order, label, or value. That makes it easier to understand why the same data can produce different answers when the addressing direction changes.
Advanced Calculation Choices
You can test ranks, totals, differences, percent differences, window values, lookup values, index, size, first, last, z score, cumulative percent, and percent rank. These options cover many common analytic cases. Running values show growth over time. Window values smooth noisy rows. Ranks show position. Percent calculations explain contribution and change.
Reading the Output
The selected result column shows the main answer. Supporting columns provide checks for common formulas. Use them to confirm whether the calculation resets correctly for each partition. Export the table when you need to save examples, compare settings, or document a reporting method.
FAQs
What is a table calculation?
A table calculation is a calculation applied to visible rows after data is grouped. It can create running totals, ranks, percentages, differences, and window results.
What does partition mean?
A partition is a separate group of rows. Each partition resets the calculation, so East and West regions can have separate running totals or ranks.
What is addressing order?
Addressing order is the row sequence used by the calculation. Running totals, lookup values, and differences change when row order changes.
How is percent of total calculated?
Percent of total divides the current value by the sum of its partition. The result is multiplied by 100 to show contribution.
What is a window calculation?
A window calculation uses a range of rows around the current row. It can return a sum, average, minimum, or maximum for that range.
Why does rank change after sorting?
Rank is based on value order, but the displayed rows may follow another order. Sorting helps you compare position and row sequence clearly.
What does lookup offset mean?
Lookup offset selects another row relative to the current row. Use -1 for the previous row, 1 for the next row, and 0 for current value.
Can I export the calculated table?
Yes. Use the CSV button for spreadsheet data. Use the PDF button for a clean report table that can be saved or shared.