I am adding a field with numbers to the Rows area in a Pivot Table, and I would like to show the total (sum) of those rows underneath as a subtotal. I managed to get the subtotal line to show up by clicking Custom / Sum under Subtotals in the Field Settings, but it does not seem to add up the numbers and actually show a subtotal on that line. How do I get it to show up?