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 |
All times are GMT +1. The time now is 07:57 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com