Controlling Subtotals in Pivot Table when dimensions are switched.

[retko1985]

Hello,

please refer to the attached QVW.

I have Country as second dimension, because of Rank Sort. Now when I click Vencouver, I see subtotal for vencouver, but I want to see still for whole country (Canada).

Is it possible?

Thank you.

[retko1985]

Exactly what I wanted. Thank you.