Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Exclude pivot table data from pivot chart? | Charts and Charting in Excel | |||
Using a Pivot Table Calculated Field to get a Unique Count | Excel Worksheet Functions | |||
Disappearing Data Items on Pivot Table -Updated Question | Excel Discussion (Misc queries) | |||
Group Field in Pivot Table €“ Not Enough Room | Excel Discussion (Misc queries) | |||
Pivot table show pages but omit those without data | Excel Discussion (Misc queries) |