Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
i am using a straight table in that i need to sum all the values in a column i.e..,if i have values 10,20,30,40 in a column i need sum(10,20,30,40) i.e.., 100 to repeat in other column could any one help out me to write the expression for that.
Thank you
Try using RangeSum()
Eg: RangeSum(Exp1, Exp2, Exp3, Exp4)
you can use the same expressions
if expression for lablel1 column is sum(Expression2), for label 2 sum(Expression2), ......
sum(Expression1) + sum(Expression2) + sum(Expression3)
or you can use the label name as in image
label1 + label2 + label3
Tq sunny
But Its not working..,
i have only one expression and i want to repeat the sum of that expression in second expression..
1st expression 2nd expression
10 100
20 100
30 100
40 100
I think u can understood some what better by seeing this
i have only one expression and i want to add 2nd expression to my straight table which repeats the sum of row values in 1st column .
1st expression 2nd expression
10 100
20 100
30 100
40 100
Thank you
Let say your first expression is Sum(Sales). Add the second expression as Sum(TOTAL Sales)
maybe using Total
or post the 1 st expression
sum(costinpatient)/count(Distinct membnr).
May be this:
Sum(TOTAL Aggr(Sum(costinpatient)/Count(DISTINCT membnr), YourChartDimensions))