Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
In the attached file, under total column and row total the value is 2, but i want the sum of the rows i.e. 5.
My expressions for total :
if(column(1)>='95' and Column(2)<='99',1,2).
What should be the expression for it so that i get 5.
Please Help.
can you try to put Sum(expression)
Hi,
Just try with Sum(if(column(1)>='95' and Column(2)<='99',1,2))
or
Select Total Mode->sum of Rows
Regards
Its a Pivot Table..
I have already tried its not working.
Hi,
kk then you dont get Total Mode my bad
But according to your expression it is working fine
try with Sum(Expression)
Regards