Pivot Tables

[renee35]

I have 2 Pivottables that I need to merge into one. Is there a way to do this? I was trying to work with one Pivottable and list the other data in a spreadsheet and create a formula to bring it into the table, but I keep encountering problems. Any solutions on how this can be accomplished is greatly appreciated. Below is an ex. of what I am trying to do:

Mgr. $ Qtr Books
Fred 0 4 (need this from other table)

Thanks!!!

T-

Thanks a bunch!!

-T

 

[xlbo]

erm - exactly how is this anything to do with MS SQL Server Reporting Services ?

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question