1 Reply Latest reply: Sep 3, 2018 9:28 AM by Andrey Krylov RSS

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

    Daniel Tam

      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.