I have a pivot table with a calculated field called potential units. The
formula is (1 - Closure Rate) * Net Units. The column headers are individual
months of the year. The calculated field works fine for the individual
months, but the total always returns a 0. Any help would be greatly
appreciated.