View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Hood
 
Posts: n/a
Default Combining Pivot Table Source Data

What if I have two lists in two files each with about 59000 rows but with the
same structures. Multiple Consolidation only seems to allow me to summarize
on one key. I need the resulting pivot to summarize by sales, product group,
and period number. If only I could have more rows in one file !