Total in Pivot Table

[gatarossi]

Dear all,

In my pivot table, for example, I have 20 customers with their sales
amount. Then I made a sort by sales amount and for presentation I put
in pivot table to show the 10 bigger customers.

But my problem is that the total only sum the 10 customer selected and
I would like that the total represents the sum of all customers.

I have been tried to click in pivot table - options and flag the field
- selected subtotal in hidden itens, but it is not working.

Could you help me with this matter???

Thanks in advance!!!

André