A calculated field is a field that takes existing database fields and adds logic to them, allowing you to build new data from old data. A calculated field does one of two things: it calculates database fields to produce a value that isn't directly recorded in the database, or it doesn't.
Each sales person receives a 3% incentive if they sell more than 100 units in this example. The bonus amount is determined using 3 percent of the Total field, and the calculated field formula checks the value in the Units field. Here's the final result, with the bonus displayed in the appropriate rows.
To begin, choose any cell in the pivot table. Then, on the PivotTable Tools ribbon's Options tab, select "Fields, Items & Sets," then Calculated Field. Then, from the name drop-down list, choose the calculated field you want to work with. You can now make any changes to the formula that you like.
I would suggest Absolute reference in 13:30 for the calculation of percentage
Hafiz Muhammad Talha
kindly share your slides for revision
Sohel Khalid Nadaf
How to get dataset
I am looking for this course in Telugu language, Is there any possibilities in Telugu.
Nitesh kumar gupta
nice course all the video explained very well from scratch to advance
Overall Lectures are good but also provide the practicing spreadsheets for students.