Pivot Table static columns

[BrianR]

Is there a way to add static columns to a multi-worksheet pivot table?

My multi-worksheet pivot table is working fine, but I would like to carry
one or two additional columns of raw data into my pivot report without
summing or counting them. I only want to count the first 2 colums and show
the associated data in the next two columns.

Any suggestions?

 

[ryguy7272]

Can you append the data onto the right side of your Pivot Table. Pivot
Tables are very powerful, but they won't allow you to insert data into the
table itself. You could copy & paste-special the data, and then manipulate
it (I do that all the time). Turn on the macro recorder before going through
the process and you will see some interesting code; maybe this will give you
some additional ideas.

Regards,
Ryan---

 

[BrianR]

Thanks for the suggestion Ryan. Unfortunatly that won't work in this case
because I'm using 2 seperate worksheets for input and when I run the pivot,
it combines the two main columns into one in the table if there are duplicate
rows.

-Brian

 

[ryguy7272]

Hummm, I think that violates the integrity and the concept of the Pivot
Table, which performs some type of analysis sum, count, etc., of the data
within the bounds of the table. Or, I'm misunderstanding your need... Can
you give a specific example. Maybe if you describe the problem with some
additional dimension, someone will be able to offer a viable solution.

 

[Ashish Mathur]

Hi,

You can try to use a calculated item formula inside the pivot table.

--
Regards,

Ashsih Mathur
Microsoft Excel MVP
www.ashishmathur.com