MATCH Formula

  • Thread starter Thread starter moglione1
  • Start date Start date
M

moglione1

Hi all,

I am using a pivot table to summarise a mass of data. After I create
the pivot table I use formulas to calculate various things. Now as the
pivot table can always have more/less columns/rows I need a way to do a
calculation that will look for the TOTAL GRAND TOTAL in column Q45.

I thought a Vlookup match would work but I do not lookup anything in
the formula. I just need to return the column value of where the total
column meets the grand total column.

PLEASE PLEASE HELP
 
Try using the GETPIVOTDATA formula:-

GETPIVOTDATA(data_field,pivot_table,field1,item1,field2,item2.....
 

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 tables Grand Totals Column 1
How do I perform extended calculations in a Pivot Table in Excel 2 4
Pivot table grand total location 1
I can't see Grand total rows even though the option's switched on 2
Grand total sum of formula 6
Pivot Table Column Totals - XL2003 5
Grand Total for Rows not Working in a Pivot Table 1
calculate grand total 2

Back
Top