[Pivot table] How to ignore hidden value in total/subtotal

[Anonymous]

Hi QS experts, i hide some rows in pivot table and i hope the total and subtotal value can ignore the hidden row., but the result returned has no change. How should I do? Thank you.

[andrey_krylov]

HI, Daniel. Try to aggrigate your expression

Sum(Aggr( YourExpression, dim1, dim2, dim3) )

dim1, dim2, dim3... -  all your dimensions.