Today the Pivot Transform has many great options. See below.
How about adding Percent of Column total.
It can be calculated as the pivot row value divided by the sum of column
Pivot
Description
Creates a pivot table to summarise values for one or two columns.
Inputs
One.
Sum show the sum of the values. Non-numeric and empty values are ignored.
Minimum shows the smallest value. Non-numeric and empty values are ignored.
Maximum shows the largest value. Non-numeric and empty values are ignored.
Average shows the arithmetic mean of the values. Non-numeric and empty values are ignored.
Median shows the median of numeric values in the column. Non-numeric and empty values are ignored.
Mode shows the mode of numeric values in the column. Non-numeric and empty values are ignored.
Standard deviation is the sample standard deviation (equivalent to Excel function stddev.s). Non-numeric and empty values are ignored.
Count shows the number of values. Empty values are ignored (a value that contains whitespace is not considered empty).
I have thought about this a bit. It seems there are a lot of ways this could be done. Do you mean to add extra % columns/rows. e.g. the red figures below:
Or instead of the existing totals?
Or do you mean to alter the existing values in the table?
Perhaps you could provide an image of what it looks like now and what you would like it to look like.
Another alternative is to have a new ‘range’ transform that let you modify all the values in a table into a range (default 0 to 100) based on either the minimum/maximum/total value in each column, row or table.
This gets more tricky if you are pivoting on 2 values.
I am still thinking that this might be more flexibly done as a ‘range’ transform. In the above case, do the Pivot then add a Range transform to convert the values into the range 0 to 100 based on the sum of the column. It is an extra transform, but it means you can convert anything to a percentage, not just a pivot table.
You can use Num Format to tweak the decimal places and Insert to add a % symbol afterwards.
It is a bit more complicated than just calculating percentages based on sums, but a lot more flexible. For example you can scale each row so the maximum value in each row is 1.0.
What do you think? Any suggestions for a better name than Scale?