FSG Reports - i want a row to display the percentages based on values in each column and the total c
I'm looking for a way to display some percentages as follow:
In Row 1, i have managed to get the values i need in the respective columns e.g.
Column 1 - $1000; Column 2 - $3000; Column 3 - $6000; Column 4 is the total i.e. $10000
In my second row, i want to show the percentages of the values in each column divided by the Total i.e.
Column 1 - 1000/10000 = 10%
Column 2 - 3000/10000 = 30%
Column 3 - 6000/10000 = 60%
Column 4 - 0000/10000 = 100%