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