Hello,
I tried pivot table in numbers and Fields are showing up as Column A, Column B, Column C etc rather than the field name. This makes the job really difficult as I need to go through the main sheet to identify which each column represents. Any idea how can I see the field name / heading in the field to select instead of Column A, B, C etc.
MacBook Air 13″, macOS 12.6
Numbers shows Column A, Column B, etc. because your columns don't have headers. Yes you have put titles but they are in a "normal" row.
Select your table and in the Format sidebar, section Table, sub section Headers and Footers, give one Header row to your table.
It might also be useful to set one header column.
BTW you don't have to post two messages to include pictures, you can mix text and picture in the same post.
Numbers shows Column A, Column B, etc. because your columns don't have headers. Yes you have put titles but they are in a "normal" row.
Select your table and in the Format sidebar, section Table, sub section Headers and Footers, give one Header row to your table.
It might also be useful to set one header column.
BTW you don't have to post two messages to include pictures, you can mix text and picture in the same post.
You don't show a screenshot of your data table, but I am guessing you don't have labels in the Header Row there. Add labels and refresh the Pivot Table.
SG
screen shot attached. see on the right side where you can see the fields Column A, B,C etc where as I expected the table to show me the Row heading / label
regards
this is my table heading which is picked as Column A, B, C
Wonderful. It works with an appropriate table. Earlier I was using an excel file in numbers, hence the issue.
Appreciate your timely support.
numbers pivot table
