May 13 2020 11:42 AM
Can a Sub Total in a Pivot Table be used in a calculation? I have a Pivot Table that groups projects by Category (there are 4 categories). I am then summing the labor by craft (Electrician (EL), Plumber (PL), etc.) in the Sub Total. I would like to use the Sub Total in a calculation (e.g., (Sub Total/6.768/No of EE) where No of EE is another field (value) in the Pivot Table.
Example
EL PL
Category 1
Project 1 50 75
Project 2 65 25
Sub Total 115 100
Calc. 2.43 2.46
No of EE 7 6
May 13 2020 10:51 PM
@Purfive You can try using =SUMIFS to sum all the values with a given criteria as required by you.
May 14 2020 12:19 AM
@Purfive I suggest you have a look at the GETPIVOTDATA function. It allows you to pick-up values from within a pivot table. You could set-up some criteria outside the PT, dynamically get the data from the PT and then perform your calculations. See picture attached for an example.