Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
i am facing issue while calculating percentage.
original table
A B C GRANDTOTAL(A+B+C)
1 2 3 6
2 4 2 5
3 1 2 6
NOw output table should be like this
A B C GT
16.6 % 33.3 % 50 % 100%
lIKE THIS I NEED TO CALCULATE PERCENTAGE.
LOAD
A/(A+B+C) as A
B/(A+B+C) as B
C/(A+B+C) as C
1 as [GRANDTOTAL(A+B+C)]
FROM ...