Is it possible to show a calculated column which is the percentage of the total for that grid column? let's say I have a data tablie like
[Item],[Quantity]
item A, 3
Item B,5
Item C, 2
I can show a total row, but what I want to do is to show the percentage of total for each row, ie
===
[Item],[Quantity],[%]
Item A, 3, 30%
...
Total, 10
===
Is this possible?
[Item],[Quantity]
item A, 3
Item B,5
Item C, 2
I can show a total row, but what I want to do is to show the percentage of total for each row, ie
===
[Item],[Quantity],[%]
Item A, 3, 30%
...
Total, 10
===
Is this possible?