On pivottable wizard step 1 choose "multiple consolidation ranges"
hope it helps