Issue in total of pivot table.

[Anonymous]

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.

[ecolomer]

can you try to put Sum(expression)

[PrashantSangle]

Hi,

Just try with Sum(if(column(1)>='95' and Column(2)<='99',1,2))

or

Select Total Mode->sum of Rows

Regards

[Anonymous]

Its a Pivot Table..

[Anonymous]

I have already tried its not working.

[PrashantSangle]

Hi,

kk then you dont get Total Mode my bad

But according to your expression it is working fine

try with Sum(Expression)

Regards