Jan 12, 2017 8:01 AM
| Last Modified: Jan 12, 2017 8:48 AM
Percent of Total Utility v0.2.jmpaddin
This Add-in generates formula columns calculating the percent of total (row-wise) for the selected numeric columns. These columns are especially useful when creating stacked bar or column chart of the columns of interest and you wish for your scale to be percent of total rather than a sum.
Usage: After installing this Add-in, select the set of columns in the data table, then choose "Percent of Total Formula Columns" from the Add-ins menu.
Note: The formulas generated by this Add-in will tolerate missing values row-wise for all but one of the selected columns.
When creating a stacked bar or column chart, the resulting plot is of the composition, rather than the total: