Multiple Pivot Tables on 1 sheet ?

[ilcaa]

Is this possible? I want to provide different tables that show different views of the data, can i place multiple 4 pivot tables on 1 sheet?

thanks

 

[texasalynn]

yes - on the third step of the pivot table click on the Existing worksheet, then click on the cell you want the table to start on

HTH

 

[ilcaa]

thanks but what i wanted to do was place multiple pivot tables on a sheet,

 

[texasalynn]

That's what I was answering - maybe need to give you a little more information. When you create the multiple pivot tables you would then on the third step of the pivot table click on the Existing worksheet, then click on the cell you want the table to start on

 

[ilcaa]

"Cant Group that Selection" Pivot table

I sometimes get error messages because i cannot group a particular selection within a pivot table...

I cant seem to figure the logic when it comes to grouping or not, what are the hard rules when trying to group within a pivot table and why won't some table be groupable?

thank

 

[xenou]

What are you trying to group? What is the data?