Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Calculations based on PivotTable information
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formula based on text information | Excel Worksheet Functions | |||
increment a column based on information in another column | New Users to Excel | |||
Date/time range based calculations | Excel Discussion (Misc queries) | |||
Is there away to have specific cells unlock based on the entry of information in another? | New Users to Excel | |||
Can you conditional format based on information in cell comments? | Excel Worksheet Functions |