Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #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

  #2   Report Post  
Debra Dalgleish
 
Posts: n/a
Default

The row headings show once in a Pivot Table, and there's no setting you
can change, to force them to repeat. You could create a copy of the
pivot table, and fill the blanks, to do the lookup. Perhaps you could
use INDEX/MATCH formulas to work with the data in the pivot table, but
would have problems if the layout changed.

Why don't you want to use GetPivotData?

Alastair Scott wrote:
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



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

  #3   Report Post  
Alastair Scott
 
Posts: n/a
Default

Thanks for the info.

Don't want to use GETPIVOTDATA as I'm unfamiliar with it (despite computing
degree). Suppose I'll need to sometime...

"Debra Dalgleish" wrote:

The row headings show once in a Pivot Table, and there's no setting you
can change, to force them to repeat. You could create a copy of the
pivot table, and fill the blanks, to do the lookup. Perhaps you could
use INDEX/MATCH formulas to work with the data in the pivot table, but
would have problems if the layout changed.

Why don't you want to use GetPivotData?

Alastair Scott wrote:
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



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html


  #4   Report Post  
Zoya
 
Posts: n/a
Default

Scott,

I use ISBLANK function to check if the cell is emply and IF function to
point to the different cell.

If you create your LookUps in column F you need to point F1 to the cell
where your Field1 is (for exp =A3), then in F2 you can enter this formula
=If(ISBLANK(A4),F1,A4)

Hope it helps.


"Alastair Scott" wrote:

Thanks for the info.

Don't want to use GETPIVOTDATA as I'm unfamiliar with it (despite computing
degree). Suppose I'll need to sometime...

"Debra Dalgleish" wrote:

The row headings show once in a Pivot Table, and there's no setting you
can change, to force them to repeat. You could create a copy of the
pivot table, and fill the blanks, to do the lookup. Perhaps you could
use INDEX/MATCH formulas to work with the data in the pivot table, but
would have problems if the layout changed.

Why don't you want to use GetPivotData?

Alastair Scott wrote:
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



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html


Reply
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 06: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 03:40 PM.

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

About Us

"It's about Microsoft Excel"