Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table Question | Excel Discussion (Misc queries) | |||
Pivot Table Question | Excel Discussion (Misc queries) | |||
Pivot Tables, Help? | Excel Discussion (Misc queries) | |||
Jon Peltier - Pivot Table Result for yesterday's "Complex Chart" Question | Charts and Charting in Excel | |||
pivot table question, sum fields? | Excel Worksheet Functions |