This Analytics Edge wizard lets you perform typical math calculations without using formulas, including a number of series calculations across rows or down columns.
Add a New Column
Add a new column to your table, where the new column will contain the results of the calculation.
New Column Name – Enter a name for the column to be added.
Column A – Select the first column to use in your math operation, optionally By Name or by position (column letter).
Calculation – Select the math operation you want to perform. Depending on your selection, some of the other options will change. Operations usually involve 2 columns (A and B) such as Adding A + B.
Note that some functions involve a range of columns, such as Average (A to B). In this case, the function will average the selected columns A and B, as well as all columns between them.
Column B – Depending on the function you choose, you can enter a Value (click the button to use an Excel cell reference to get the value). The second option is to use an Aggregate, such as Column Sum. The third option is to pick a specific column By Name or by position (column letter).
Replace Existing Values
Choose to replace the values in the table with the results of the calculation, such as a rolling average or percent of column total.
Select Columns – Select one or more columns By Name or by position (column letters).
ZZZ Last Column – automatically selects columns to the end. It is not necessary to select all the columns — just pick the first column and ZZZ Last Column. This feature is typically used with reports that have an unknown or inconsistent number of columns, such as days of the month.
Operation
Math – select an operation, and enter a value or use the button to use an Excel cell reference to get a value. This performs the operation on the selected columns.
Cumulative – select a function and a direction. Performs a cumulative operation down each column selected, or across the rows of the selected columns. For example, a cumulative sum down each column (a running total) where each cell would contain the sum of all of the cells above it.
Repeating – select a function and a direction. Performs the operation down each column selected, or across the rows of the selected columns. For example, repeating difference down the column would replace each cell value with the difference from the cell above it.
Rolling – enter a value and select a function and direction. Performs a rolling function down each column selected, or across the rows of the selected columns.
Relative – select the type of comparison, the axis to compare to, and the aggregate to compare with. Each of the selected columns is changed to that new comparison value.