Chapter 3
Working with PivotTables
Section 5
Adding a Calculated Field and KPI
Normal 0 false false false EN-IN X-NONE X-NONE /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-parent:""; mso-padding-alt:0cm 5.4pt 0cm 5.4pt; mso-para-margin-top:0cm; mso-para-margin-right:0cm; mso-para-margin-bottom:10.0pt; mso-para-margin-left:0cm; line-height:115%; mso-pagination:widow-orphan; font-size:11.0pt; font-family:"Calibri","sans-serif"; mso-ascii-font-family:Calibri; mso-ascii-theme-font:minor-latin; mso-hansi-font-family:Calibri; mso-hansi-theme-font:minor-latin; mso-fareast-language:EN-US;} You aren't using PowerPivot to manage your data model, but you still want to implement calculated fields and KPIs. We'll use PivotTable options and conditional formatting as a workaround. - Select a cell in your PivotTable; click on Analyze, and then on Fields, Items, & Sets, and finally on Calculated Field - Name your calculated field and type the desired formula, using existing field names when needed - Select the resulting calculated field cells; click on Home and then on Conditional Formatting and choose your desired rules and visual indicators