This video will show how you can create a logical test or IF formula within a Pivot Table by using calculated fields, and not using the GETPIVOTDATA function. This video also answers why a logical formula in Excel has an incorrect grand total and what is a workaround about this problem. Finally, this shows that you can also created nested IF within a calculated field.
