Yes, unfortunately this is how it works... There is a work around though - use Advanced Aggregation (function aggr()) and force the summary of the detailed values at each level.
For example, if your Picot Table has 3 Dimnsions - Dim1, Dim2, and Dim3, and an expression sum(Sales), you could use the following expression to force Sum of lines:
Have you looked at partial sums (Presentation tab)? If you put a partial sum on your top dimension, then that should total up the columns at the bottom. If you prefer your subtotals at the top that can be changed by using the Subtotal section of the Presentation tab.
