Building User-Defined Calculations Inside Pivot Tables
Learn how to build user-defined calculations directly in your pivot tables without modifying the raw data. Mac McClelland walks through creating a calculated field to compute totals that don't exist in your source data—no need to edit the underlying spreadsheet. Watch to see how it's done.
From the course “K2's Excel Best Practices And Features” (2 CPE credits, Computer Software and Applications, Intermediate):
https://www.cpetoday.com/course/k2s-excel-best-practices-and-features-24c-ebpf
Taught by Tommy Stephens — Partner, K2 Enterprises.
More from Tommy Stephens: https://www.cpetoday.com/instructor/tommy-stephens
CPE Today offers live webinars, Live Replays and self-study for CPAs and accounting professionals. NASBA-sponsored (ID 167619) and an IRS-approved CE provider. https://www.cpetoday.com/
#Excel #PivotTables #CalculatedFields
More from this course
3:49
The calculated field myth: You CAN build custom formulas in pivot tables
4:01
Stop Cleaning Data Manually—Automate It in Power Query
4:00
How to automate repetitive reports without learning to code
3:56
Why Those Old Text-Splitting Formulas Are Evil
3:58
One Formula, Multiple Cells: Dynamic Arrays Explained
3:55
LAMBDA: Create Custom Formulas You Reuse Forever
3:55
LAMBDA: Create Custom Formulas You Reuse Forever