Once you have a result from your question, you can add additional columns as table calculations based on the data in the table. This functionality is similar to functions in Excel. To add a table calculation, click on the three-dot menu for the column in the table's header or click the "+ Table Calculation" button.

The sum function sums up the numeric column it operates on. For example, you could use this function like [orders.total_revenue] / sum([orders.total_revenue]) to get the percent of the total for the total revenue column. This will divide each row of the total revenue column by the sum of its total using this function.

The cumulativesum function creates a running total of the column going in the sort order of the column. For example, if you used cumulativesum([orders.total_revenue]), each cell in your calculated column will be the summed up total of all previous cells in the orders.total_revenue column.

The offset function allows you to access the value of a cell that is a certain number of rows away from the current cell. For example, if you used offset([orders.total_revenue], 1), each cell in your calculated column would be the value of the cell in orders.total_revenue that is 1 rows away from the current cell.

The cell_value function allows you to access the value of a fixed cell at a specific row number. For example, if you used cell_value([orders.total_revenue], 1), all cells in your calculated column would be the value of the cell in column orders.total_revenue at row 5.

You can use the arithmetic operations +, -, *, and / to combine scalar values or other columns. For example, you could multiply the total revenue column by .78 then add in the shipping value [orders.total_revenue] * .78 + [orders.total_shipping].

If you have additional questions about the types of formulas and functions you can use in table calculations, you can reference the developer docs here.