I have a spreadsheet where the first row contains the column names and all the others have data. I want to create a Pivot Table from only a subset of the rows. Because the subset starts on the row 5, it does not include the column names from row 1, and when I create the pivot table, the “Available Fields” contains the data from row 5 not the column labels in row 1. Is there a way I can create a pivot table from this subset and have the “Available Fields” list the column names?
example.ods (9.5 KB)
Add a Filter column in C, enter a value in to be calculated rows (e.g. select C5:C7, enter x and close with Alt+Enter to write the value into all selected cells). Create the pivot table of A1:C7 as usual, on the pivot table right click for context menu, choose Filter…, Field name Filter, Condition =, Value x, OK.
See attached
96207-ask-example.ods (12.1 KB)
1 Like