Pivot: Selecting data with Query Result

[Glenn]

Hello Community,

I am using Pivot functunality to get access to data that is stored in a
classical table.

As I result from selecting the name in the the page field, I would to
display the corresponding values like customer number and post code just
below the name field but not in the data field. Moreover, I want to be able
to enter the customer number once and another time the name, whereas each
time the "related field" is filled correspondingly.

Could anybody help me on that issue. Thanks and cheers.

Glenn


Format of the source data:

#Name #Customer Nr. # Postcode # Revenue 2000 # Revenue 2001 ....

 

[Debra Dalgleish]

You could use VLookup formulas in cells adjacent to the pivot table, to
pull the data from the customer table. There's an example here, using an
order form:

http://www.contextures.com/xlOrderForm01.html