Forum Discussion

Copper Contributor

Sep 12, 2022

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 conta...

excel

DexterG_III

Iron Contributor

Sep 12, 2022

sheridan60 How are you importing the source data? Does the download from Replicon go directly into a pivot table or does it first go into a table from which you are creating the pivot?

In the helper table for rates you created, is it possible to pull information (Hours) from the Replicon datasource and calculate the total cost there (bypassing the need for a calculated item)?

Dexter

sheridan60
Copper Contributor
Sep 12, 2022
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.
- DexterG_III
  Iron Contributor
  Sep 12, 2022
  sheridan60 While Vlookup will pull a value from a single cell (the first match in the lookup table - a single workorder entry), using sumif will pull values from several cells. Using sumif should allow you to pull the total by workorder rather than workorder entry.
  - sheridan60
    Copper Contributor
    Sep 12, 2022
    Can I use sumif/sumifs if I have 3000 different identifiers, without entering detail for each one?