Excel pivot row label

Question

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.

Answer 1

We need to see your (sample) file and tell us which field you want as row label.

Andreas.

Answer 2

We need to see your (sample) file and tell us which field you want as row label.

Andreas.

Please see this OneDrive shared file link: Sheet1

How can I get totals corresponding to the rows for the columns group and Location?

Answer 3

How can I get totals corresponding to the rows for the columns group and Location?

Viswan,

Not sure what you want...

I used power Query to unpivot the data (and filtered out the "temp" items). Sample file:
https://www.dropbox.com/scl/fi/kecgxc9tw0rt37c4tqmto/9c599210-ce96-4e55-833e-05952de6af19.xlsx?rlkey=2h4yyf6g12vbi39vdiohbjjda&dl=1

Andreas.

Answer 4

I am looking for a cross tab, just as you see above with field Title as the pivot row header and field Group and Location as the row header. The intersection will have the sums corresponding to the pivot. Will you know how to do this using the Pivot table?

This is what I attempted above. Is it possible to do this using the Excel Pivot table function?