My subtotals are not totaling to the right amount in my pivot table:
I would expect it to show 7 instead of 6 for the Hrs Logged column. I am summing the hours logged column. Thanks!
My subtotals are not totaling to the right amount in my pivot table:
I would expect it to show 7 instead of 6 for the Hrs Logged column. I am summing the hours logged column. Thanks!
I think I answered my own question. The subtotal function is working but it just looks like it’s not because I rounded the Hrs Logged. The subtotal is using actual values (before rounding) to calculate the subtotal. I decided to forgo the rounding and just show the actual values.