Pivot table question
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 |
All times are GMT +1. The time now is 04:41 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com