How to extract the full row label from Excel PivotTable?

I have a PivotTable in Excel with multiple layers of row filtering: Month > Region > Product (1 > EU > Dessert). When I mouse over the row, I am able to see the full row label (1 - EU - Dessert): pivot row label I know that I can go to PivotTable Tools > Design > Report Layout > Show in Tabular Form and then Repeat All Item Labels and then use a simple formula to get the full row label into a single cell, but I am trying to avoid changing the format of the PivotTable. Ideally, I would like to maintain the formatting of the PivotTable seen in the image above, but extract the full row label (using a formula) from the PivotTable for use in another cell. Thanks!

asked Dec 18, 2020 at 19:16 23 6 6 bronze badges Commented Dec 18, 2020 at 19:24 Does this answer your question? Extract Pivot Table Row Label (not value) Commented Dec 18, 2020 at 19:26

Not exactly. I don't want the names of the literal rows (from the PivotTable fields area) like the author of the previous question wanted. I am looking to effectively extract the full name of the individual record in the table: 1-EU-Dessert

Commented Dec 18, 2020 at 19:54 Related questions How to access the field name of a PivotCell.RowItem(n)? Excel VBA - How can I determine number of row label fields in Pivot Table? Get value of pivotfields for a particular cell Related questions How to access the field name of a PivotCell.RowItem(n)? Excel VBA - How can I determine number of row label fields in Pivot Table? Get value of pivotfields for a particular cell Excel pivot table: How to transpose multiple value in column to a column labels Excel Pivot Table - How to retrieve value of cell in Rows section Custom row labels in PivotTable Filter pivot table row label using Excel VBA Refer to PivotTable name in cell in GetPivotData Extract Pivot Table Row Label (not value) Use column labels from an Excel table as the rows in a Pivot Table

0 Know someone who can answer? Share a link to this question via email, Twitter, or Facebook.

excel-formula
pivot-table

The Overflow Blog

Linked

Hot Network Questions

Subscribe to RSS

Question feed

To subscribe to this RSS feed, copy and paste this URL into your RSS reader.