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
![](https://s2.save4k.ru/pic/nVqtPjsTdBI/mqdefault.jpg)