Sum of Rows in pivot table

[djallelsadki]

Hello,

I have a pivot table, with :

Three dimensions "X", "Y", "Z" and one expression wich calculates the sum of the field "H"

A variable "V" filled through a slider

In my expression i have

if (sum (H)> V, sum (H))

The problem is in the total

expression works well but the total does not change, I would like to have the sum of rows and not the expression total

see the attachment file

Thank you for your answers

[#2]

Hi,

see your modified example.

Good luck!

Rainer

[Sokkorn · Accepted solution]

Hi,

Try to change your expression from if(sum(H)>V,sum(H)) to SUM(if(H>V,H,0))

Hope this work.

Regards,

Sokkorn Cheav