Forum Discussion

Copper Contributor

May 28, 2020

Add calculation to Pivot Table with data from Field with Running %s

I have a PivotTable that contains info regarding transactions of different products, and how long each product usually takes to process. I have the product types as the rows of the table, and for the...

excel

Formulas and Functions

Macros and VBA

mtarler

Silver Contributor

May 28, 2020

jcarrigan Did you try using GETPIVOTDATA formula? you can call out multiple fields to pull out the specific values you want. Although multiple rows have the same names in the first col you show I'm sure there is another field that differentiates those groups.

jcarrigan
Copper Contributor
May 29, 2020
mtarler I initially used GETPIVOTDATA for the table to the right, but I switched it to the hard cell references since those supported dragging the fill handle when different filters yield a different number of rows.