Multiple Pivots - separate grouping

You have to base your pivots on separate caches - since 2007 excel by default makes next pivot from the same dataset using a common cache thus gruping or filtering in one pivot influences other. You coudl call "old (ex2003-) style pivot creator with keyboard shortcut Alt D P - which comes from the Excel 2003 menu bar: Alt - D = Data menu, then P to select the Pivot chart wizard. See also http://office.microsoft.com/en-gb/ex...010226675.aspx and http://gasperkamensek.wordpress.com/...e-pivottables/