Excel 2011 Multiple Range Pivot Table

[awcolman]

Hello And Thank You All!!

Thanks to everyone for all the help! I just learned the wonders of pivot table WOW!

I have looked and experimented on how to include multiple ranges on a pivot table in excel 2011, i have found how to to it with the wizard but i can not find the wizard.

Can some one just help me out on how to separate the ranges in the selection box? They are going to be going across sheet is that makes any difference.

Thanks again so much

 

[Smitty]

See:

<CITE>www.contextures.com/xlPivot08.html</CITE>
<CITE></CITE>
HTH,

 

[awcolman]

Thanks i found out the command is alt+command+p an it brings up the wizard.

Any idea why when i make the pivot table with multiple ranges labels differently? the colomns are all labeled the same and i included the same information...


Mulitple Ranges


Single Range



Uploaded with ImageShack.us

 

[Smitty]

I don't have a Mac to test on, but aren't those screen shots the same?

 

[awcolman]

yes sorry i didnt catch that fast enough. its changed now