View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Carlene Carlene is offline
external usenet poster
 
Posts: 4
Default 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