How To get calculate the % of the total of another field?
See my image below.
I would like to know how to calculate the % of the
red arrow of the total of the
blue arrow. I tried making an aggregate formula and I tried every option under count and %, but no luck. Do you know how I can calculate this?
So the formula should be:
Row 1: (10/382)*100 = 2.61%
Row 2: (13/382)*100 = 3.40%
etc.
Any help would be great. Thanks!