Pivot Table Question

Copper Contributor

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

2 Replies

@Purfive You can try using =SUMIFS to sum all the values with a given criteria as required by you.

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

Screenshot 2020-05-14 at 09.13.24.png