New to 2007... I created a pivot table that consolidated two ranges in different workbook/sheets -- both laid out exactly the same way. I must just be really thick, but I expected it to be the same as if I'd just done a pivot table from one of the two tables -- in other words, with fields for every column. Instead I get row, column, value, and page fields. This is where I really DO think I'm thick -- I can't figure out how to use these to get anything meaningful...
If someone can point me to a good link explains why these are different, or how to use them effectively, I'd be really appreciative.
Or -- if there's another, better or easier, way to use a pivot table on consolidated -- even better!
Thanks.
If someone can point me to a good link explains why these are different, or how to use them effectively, I'd be really appreciative.
Or -- if there's another, better or easier, way to use a pivot table on consolidated -- even better!
Thanks.