Pivot table formula help
 

I have a situation where I'm trying to exclude 1 group from the %
calcualtions in the pivot table. I have gotten all the totals by adding
formuals (= conference + division * 0.03). However if I don't want the
"Blazer"s to be calculated by 3% how do I do a formula for that item in the
pivot table.

Team conference division
Whalers $134 $75
Suns $112 $80
Blazers $107 $65
Rangers $121 $56


thanks in advance
--
hard at work

Pivot table formula help
 

You can't create a formula in the pivot table that checks the team name.
Maybe you could add a column to the source data, to calculate the total
for each row of data. Then, add that field to the pivot table.

Carlene wrote:
I have a situation where I'm trying to exclude 1 group from the %
calcualtions in the pivot table. I have gotten all the totals by adding
formuals (= conference + division * 0.03). However if I don't want the
"Blazer"s to be calculated by 3% how do I do a formula for that item in the
pivot table.

Team conference division
Whalers $134 $75
Suns $112 $80
Blazers $107 $65
Rangers $121 $56


thanks in advance


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html