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.
HI, Daniel. Try to aggrigate your expression
Sum(Aggr( YourExpression, dim1, dim2, dim3) )
dim1, dim2, dim3... - all your dimensions.
Retrieving data ...