B
brettmanning24
Hello,
Hope whoever is reading this is well and can help! I have been looking online for a solution but as yet I cannot find any information.
In a pivot table if I hide / filter an item, I would still like to include this item in the subtotal / total. As soon as I hide / filer the value it is removed from the total. The item I need to hide I do not want the user to see but it is required in the calculation for the total.
Any idea's?
Thanks,
Brett
Hope whoever is reading this is well and can help! I have been looking online for a solution but as yet I cannot find any information.
In a pivot table if I hide / filter an item, I would still like to include this item in the subtotal / total. As soon as I hide / filer the value it is removed from the total. The item I need to hide I do not want the user to see but it is required in the calculation for the total.
Any idea's?
Thanks,
Brett