Pivot Table Calculated Item Solve Order Issue

If you've created multiple calculated items in a pivot table you might get into a situation where they are not showing up correctly. Somehow the calculations are wrong or don't look right for what you're trying to communicate. Often times it will be the way that the calculations are ordered that is creating the confusion. Re-arranging the sort order of the calculated items is then the solution. This video will cover what dialogue windows can be used to resolve the issue and also go through the steps of creating the pivot table with the "wrong" series of steps that lead up to the problem.