|
||||||||||||||||||||
|
|||||||||||||||||||||
|
#1
03-15-2007, 02:16 PM
|
|||
|
|||
|
Pivot table creation
I am attempting to compile information into a pivot table. One of my data labels has several columns of data under it as there are multiple entries for that data label in each row of the worksheet. When I create the pivot table it only compiles the data in the first column under the data label and doesn't continue on into the second, third, fourth, etc. columns. I don't know if there is a trick to getting this done or if it is even possible. If impossible, could I get suggestions on how to achieve the desired outcome. I only need a count of the fields under the specified data label and which ones are the same.
Last edited by zfranks; 03-15-2007 at 03:48 PM. Reason: added file |
|
#2
03-15-2007, 03:27 PM
|
||||
|
||||
|
Hi,
A sample would be useful. Can you attach a sample workbook VBA Noob
__________________
_________________________________________   Credo Elvem ipsum etian vivere _________________________________________ A message for cross posters Please remember to wrap code. Forum Rules Please add to your signature if you found this link helpful. Excel links !!! |
 |
| Bookmarks |
New topics in F1 Get the most out of Excel Formulas & Functions
|
|
|
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
Linear Mode
