View Single Post
  #1   Report Post  
Alastair Scott
 
Posts: n/a
Default How can I show all field data in a pivot table, instead of blank

I want to perform lookups ona pivot table without using the gETPIVOTDATA
function. Is it possible to show a decsription against each line of the pivot
table, instead of blank spaces? e.g.

Field 1 Field 2 Data 1
Field 1 Field 2 Data 2
Field 1 Field 2 Data 3
Field 1 Field 2 Data 4