MichaelTman
New Member
- Joined
- Apr 21, 2006
- Messages
- 18
Hello. I'm either missing something very simple or it is not possible.
I want to create a simple pivot table and place it directly above some other pre-existing data. The problem is that in 2010, a blank pivot is created prior to allowing me to drag in my fields to finish my pivot and this blank pivot will overlay my other data. I know that I can create it elsewhere and drag it to its final destination, but is there a way I can do this in one step - for example, is there a way to change the default size of the new pivot from 14x7 (I think) to something like 2x2?
Thanks in advance.
I want to create a simple pivot table and place it directly above some other pre-existing data. The problem is that in 2010, a blank pivot is created prior to allowing me to drag in my fields to finish my pivot and this blank pivot will overlay my other data. I know that I can create it elsewhere and drag it to its final destination, but is there a way I can do this in one step - for example, is there a way to change the default size of the new pivot from 14x7 (I think) to something like 2x2?
Thanks in advance.