PivotTable - Show labels on every row?
Hi there,
Is it possible to show pivottable labels on every row displayed? For instance: Basic PivotTable default layout: Item1--XXX .........--YYY .........--ZZZ Item2--XXX .........--YYY .........--ZZZ Item3--XXX .........--YYY .........--ZZZ and I would like to have it show: Item1--XXX Item1--YYY Item1--ZZZ Item2-XXX Item2--YYY ....etc... Reason being I am running a series of pivottables off of each other, and the default pivottable layout results in my second pivottable returning the majority of the results under the (blank) label due to the first column titles not repeating on each row. Thanks! |
PivotTable - Show labels on every row?
The row headings show once in a Pivot Table, and there's no setting you
can change, to force them to repeat. To create a table with a heading on each row, you could copy the pivot table, paste it as values in another location, and fill in the blanks, using the technique shown he http://www.contextures.com/xlDataEntry02.html S Davis wrote: Hi there, Is it possible to show pivottable labels on every row displayed? For instance: Basic PivotTable default layout: Item1--XXX ........--YYY ........--ZZZ Item2--XXX ........--YYY ........--ZZZ Item3--XXX ........--YYY ........--ZZZ and I would like to have it show: Item1--XXX Item1--YYY Item1--ZZZ Item2-XXX Item2--YYY ...etc... Reason being I am running a series of pivottables off of each other, and the default pivottable layout results in my second pivottable returning the majority of the results under the (blank) label due to the first column titles not repeating on each row. Thanks! -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
All times are GMT +1. The time now is 05:12 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com