I am not sure what the easiest way to do this is but I would like to add a column that shows the percentage value of that item
For example , if I have
I would like to add a column that shows what percentage of the sum total of each item is (Apples: 40% Pears: 60%)
My first instinct was to look for a way to put the maximum of a Total node into a variable but I don’t think such a thing is possible.
A neat solution would be the admin suggestion here
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.
But Im sure there is a way to do it now. Any suggestions?