Hello,

I have the following pivot table :

Continent Country Sales
__________________________
Europe France 100
Spain 200
Italy 300
Asia Japan 100
China 200


I understand that "Europe" and "Asia" do not get repeated on lines 2,3
and 5 because they act as a kind of "header" for the countries.

But the purpose of my table is to do an extraction, that will be later
used for data manipulation. Therefore I need all lines to have all
elements, something like :

Europe France 100
Europe Spain 200
Europe Italy 300
Asia Japan 100
Asia China 200

Is there a parameter in Pivot tables that will let me do this ?
Thanks
Antoine