1

Inside a pivot table, I want to store in the Baz column the sum of Foo and Bar column. How can I reference the B and C columns so Baz = Foo + Bar ? I tried to :

  1. Reference the columns by theirs names : Does not work
  2. Reference the columns by theirs ranks : Work only if I stick to a cell : B2+C2 will kinda work but B+C wont.

The example is available here : https://docs.google.com/spreadsheets/d/1v_D2e-yXpG7PlghGCiYjU0Tfw6ct2_Uaq4npQ1LkEKE/edit?usp=sharing

example pivot table1

Jean
  • 1,707
  • 3
  • 24
  • 43

1 Answers1

2

You may try this in the calculated field part of the pivot (as in screenshot)

=sum('number of units')+average('price per unit')

enter image description here

rockinfreakshow
  • 15,077
  • 3
  • 12
  • 19