Create Calculated Field Total Sum of two double indexed columns in Excel Pivot table?

36 views Asked by At

I wish to add a total sum column to a pivot table by creating a calculated field column in Excel. I am struggling with how to reference columns in my pivot table as I have two indexes for this particular pivot. I can create the Total column without issue in a pivot table with one row of headers. enter image description here

The column headers in question are circled here, is it possible to reference these in a calculated field?

enter image description here

I have tried the following formula to create a Calculated Field without success:

(Count of Outcome_1(Fail)) + (Count of Outcome_1(Pass))

I do not wish to create a manual SUM column like this: enter image description here

0

There are 0 answers