You can easily add a record by entering a value in a blank cell that has no record on the pivot table and saving it. If the record already exists and the field value is blank, the value of the existing record will be changed.

If the source record does not exist, a new record will be added.

If the source record exists (value field is blank), the existing record will be updated.

When adding a record, the record is added not only to the field in which the value was entered, but also to any fields used in the rows and columns of the pivot table with associated values.

When adding a record, the field type complements the value of the field used in the row or column. The following table describes the behavior of each field type.

Field Type	Value Completion	Remarks
Text	○
Number	○
Calculated	-	You cannot add records if you are using them in rows or columns.
Radio button	○
Check box	○
Multi-choice	○
Drop-down	○
Date	○	If you use only the Year of the subfield as shown below, the date of the unused subfield is complemented as follows. Year is used: Year= Value of the selected cell, Month=This Month, Day=1st Quarter is used: Year=This Year, Month=First Month of selected Quarter, Day=1st Month is used： Year=This Year,Month= Value of the selected cell, Day=1st Week is used： Year=This Year, Month=First Month of selected Week, Day=First Day of selected Week Day is used: Year=This Year, Month=This Month, Day=Value of the selected cell Weekday is used: Year=This Year, Month=This Month, Day=First Day of selected Weekday
Time	○	When only the Time of the subfield is used as shown below, the time of the unused subfield is complemented as follows. Hour is used: Hour=Value of the selected cell, Minute=00 Minute is used: Hour=0, Minute=Value of the selected cell
Date and time	○	If you use only the Year of the subfield as shown below, the date and time of the unused subfield is complemented as follows. Year is used: Year=Value of the selected cell, Month=This Month, Day=1st, Hour=00, Minute=00 Quarter is used: Year=This Year, Month=First Month of selected Quarter, Day=1st, Hour=00, Minute=00 Month is used： Year=This Year,Month= Value of the selected cell, Day=1st, Hour=00, Minute=00 Week is used: Year=This Year, Month=First Month of selected Week, Day=First Day of selected Week, Hour=00, Minute=00 Day is used: Year=This Year, Month=This Month, Day=Value of the selected cell, Hour=00, Minute=00 Weekday is used: Year=This Year, Month=This Month, Day=First Day of selected Weekday, Hour=00, Minute=00 Time is used: Year=This Year, Month=First Month of selected Quarter, Day=1st, Hour=Value of the selected cell, Minute=00 Minute is used: Year=This Year, Month=First Month of selected Quarter, Day=1st, Hour=00, Minute=Value of the selected cell
Link	○
User selection	○
Department selection	○
Group selection	○
Lookup	○
Record number	-	You cannot add records if you are using them in rows or columns.
Created by	-	You cannot add records if you are using them in rows or columns.
Created datetime	-	You cannot add records if you are using them in rows or columns.
Updated by	-	You cannot add records if you are using them in rows or columns.
Updated datetime	-	You cannot add records if you are using them in rows or columns.

If you are displaying details (source data of aggregated result), you can add records from the detail sheet.

The number of records that can be added from the pivot table and details is as follows.

Setting		Number of records that can be added
Pivot table		1 Record
Detail	Check "Allow Add More Than One Record Per Aggregated Cell" in the General settings	1 Record (If a row has been added in detail, the "Add" button on the command bar will not be enabled)
	Uncheck "Allow Add More Than One Record Per Aggregated Cell" in the General settings	Multiple records