Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi all,
i have a straight table output:
region VALUE % Region
AMER 10 =10/80 ie 13%
ASIA 20 =20/80 ie 25%
EMEA 50 =50/80 ie 63%
Total 80 100%
% Region is desired column results i want but when use Sum formula in expression it takes values as below:
=10/10
=20/20
=50/50
please advise how to use sum function or aggregation function and what is the syntax
thanks
Use this expression: sum(VALUE)/sum(total VALUE)
Use this expression: sum(VALUE)/sum(total VALUE)