Home |
Search |
Today's Posts |
#1
|
|||
|
|||
pivot table
Hello, I've a pivottable which is based on many Exel-Sheets. Therefor I've set the pivot with 4 individual sidefields, but it is not possible for me to select the contents of these fields. Can somebody help me ?? greetings, bvbvince -- bvbvince ------------------------------------------------------------------------ bvbvince's Profile: http://www.excelforum.com/member.php...o&userid=16482 View this thread: http://www.excelforum.com/showthread...hreadid=278320 |
#2
|
|||
|
|||
You can create a Pivot Table from multiple consolidation ranges, but you
won't get the same pivot table layout that you'd get from a single range. There's an example he http://www.contextures.com/xlPivot08.html If possible, store your data in a database, or on one worksheet, and you'll have more flexibility in creating the pivot table. bvbvince wrote: I've a pivottable which is based on many Exel-Sheets. Therefor I've set the pivot with 4 individual sidefields, but it is not possible for me to select the contents of these fields. Can somebody help me ?? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table services | Excel Discussion (Misc queries) | |||
How to create a calculated field formula based on Pivot Table resu | Excel Discussion (Misc queries) | |||
pivot table multi line chart | Charts and Charting in Excel | |||
convert excel list to pivot table | Excel Discussion (Misc queries) | |||
Problem with Pivot Table Drop-Down Menus | Excel Worksheet Functions |