How can I get the total for each dimension value in the pivot table? Currently when I enable the partial sum, I can only get the total value but not the total by each dimension value. (Please see the example below)
Then you can just drag the Region-label with your mouse to a position above the Type-label. This way you rearrange the Pivot Table to give you exactly what you ask for: One total for each Country and a Grand Total for everything.
Enrique's solution should work perfectly well for what you ask for - just do the little mouse adjustment.