User Profile
sheridan60
Copper Contributor
Joined Sep 12, 2022
User Widgets
Recent Discussions
Re: Calculated Field in Pivot
DexterG_III I am provided with a file from HR/Payroll. Apparently this is my only option. I had to join the two tables myself. I just figured out that I can use VLOOKUP and add the total for each line item to the spreadsheet I was given. I now have a total per work order per entry, but cannot get a total per work order overall. I'm not sure a pivot table is gonna work for me.Calculated Field in Pivot
Hello, I am new to Pivot Tables so please bear with me. I am trying to determine monthly costs for each job, represented by a WO#. My timesheet data is downloaded from Replicon but it does not contain the rates. I have the rates in a separate table. I have created a Pivot and joined the two tables. Now, I can see the number of hours each employee has logged for each job and I can see their rate but I need to calculate the total cost based on that employees rate. I tried to create a calculated field but it is disabled. I read that calc fields are available for all types of data except OLAP source data. I don't know what OLAP data is, but don't think my data is OLAP. Any ideas?
