LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Exclude pivot table data from pivot chart? coal_miner Charts and Charting in Excel 4 April 17th 07 07:11 AM
Using a Pivot Table Calculated Field to get a Unique Count Mike Struckman Excel Worksheet Functions 1 November 22nd 05 05:32 PM
Disappearing Data Items on Pivot Table -Updated Question GeorgeChe Excel Discussion (Misc queries) 4 August 2nd 05 03:22 PM
Group Field in Pivot Table €“ Not Enough Room Mary Ann Excel Discussion (Misc queries) 2 July 15th 05 08:22 AM
Pivot table show pages but omit those without data Angus Excel Discussion (Misc queries) 0 June 16th 05 06:04 PM


All times are GMT +1. The time now is 10:19 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"