Pivot table formula help

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
Back
Top