Calculations based on PivotTable information

J

jerry

I am trying to create calculations for Commissions based on Pivot Table
information. However, When i try to filter(change the dimension) to show
individual Salespeople the columns that i refer to in my calculations change,
thus my calculations are in accurate.

This is what i am using to calculate when all salespeople are present on the
pivot table

In Column J
IF(AND(ISNUMBER(SEARCH("*total",C5)),F5<>""),F5*0.03,"")

In Column L
IF(AND(ISNUMBER(SEARCH("*total",C5)),G5<>""),G5*0.02,"")

any help would be appreciated.
thanks
Jerry
 
Top