This video demonstrates how to create a Pivot Table in Google Sheets that includes a Calculated Field. In this scenario we have a data set of loan information. Two of the value fields are "Original Balance" and "Principal Payments Made." The objective is to create a Calculated Field in the Pivot Table that subtracts the "Principal Payments Made" Field from the "Original Balance" Field to get a new "Remaining Balance" Field in the Pivot Table Summary.

Learn more about Google Sheets Functions with this Book at Amazon.
[ Ссылка ]

Buy the complete Google Workspace User Guide at Amazon:
[ Ссылка ]

DISCLAIMER: As an Amazon Affiliate I get a commission for every purchase via these links

#GoogleSheetsPivotTable
#GoogleSheetsPivotTableCalculatedField

свернуть