Getpivot calulation

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Does anyone know how to drag a getpivot caulation to other cells, instead of
having to type into each individual cell?
 
Hi

Where the GetPivotData shows the field name in the calculation, change
that part of the reference to the cell value on the PT where the Field
name appears.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Referencing a pivot table 1
Getpivot function - 2
Adding similar update to multiple different functions at once 1
Toggle for GetPivot Data in Office 2007 Excel 2
if function checking for numerical data vs alpha characters 1
Get Pivot Function 2
Indirect(address...function help? 1
Making the same change to multiple functions at once. 5

Back
Top