This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
how can I get a field as a row label instead of it being a summary for excel pivot.
the help says that I need to place the field in the row label area where the pivot is defined. It does not do that.
I have created the table for the pivot from range links to another sheet, because the original sheet is not data structured to suit the pivot labels.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Is it possible to do this using the Excel Pivot table function?
Sure, open my sample file, move the group field into the Columns section.
Andreas.