If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Multiple pivot tables
Hi is there anyway that I can combine separate pivot tables onto the
same sheet. I have tried to create a pivot table in the same sheet as another one I have but it keeps posting an error that I have one or more invalid references so it will only allow me to create one in a new sheet. Also is there a way of having one pivot but posting multiple views of different data pivots on one sheet? |
#2
|
|||
|
|||
Multiple pivot tables
http://www.contextures.com/tiptech.html
Debra Dalgleish, has a lot of great tips on the above address hth -- regards from Brazil Thanks in advance for your feedback. Marcelo " escreveu: Hi is there anyway that I can combine separate pivot tables onto the same sheet. I have tried to create a pivot table in the same sheet as another one I have but it keeps posting an error that I have one or more invalid references so it will only allow me to create one in a new sheet. Also is there a way of having one pivot but posting multiple views of different data pivots on one sheet? |
#3
|
|||
|
|||
Multiple pivot tables
After you create a pivot table, you can add other pivot tables to the
same sheet. Leave blank columns between them, so the pivot tables have room to expand, if necessary. If you want a second pivot table based on the same data as the first one, you can select the entire pivot table, and copy it, then paste into a blank column or different worksheet. The grouping will be the same in both pivot tables, but you can have different layouts in the two pivot tables. wrote: Hi is there anyway that I can combine separate pivot tables onto the same sheet. I have tried to create a pivot table in the same sheet as another one I have but it keeps posting an error that I have one or more invalid references so it will only allow me to create one in a new sheet. Also is there a way of having one pivot but posting multiple views of different data pivots on one sheet? -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Thread Tools | |
Display Modes | |
|
|