Share via

GETPIVOTDATA formula

Anonymous
2018-09-24T05:01:55+00:00

I am perplexed by GETPIVOT formula.

2 pivot tables in sheet

First pivot table  starts in B7  Second pivot table starts in B31

This formula is in D4, I want to modify to drag right

=GETPIVOTDATA("Value",$B$7,"Date",1,"Years",2018)-GETPIVOTDATA("Value",$B$31,"Terminated ",1)

Thank you for your help

Philip

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Ashish Mathur 101.9K Reputation points Volunteer Moderator
2018-09-25T23:47:42+00:00

Hi,

Enter this formula in cell D3 and drag rightwards

=GETPIVOTDATA("Value",$B$6,"Date",COLUMN()-3,"Years",2018)-GETPIVOTDATA("Value",$B$30,"Terminated ",COLUMN()-3)

Hope this helps.

Was this answer helpful?

1 person found this answer helpful.
0 comments

4 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Ashish Mathur 101.9K Reputation points Volunteer Moderator
    2018-09-26T05:00:45+00:00

    You are welcome.

    Was this answer helpful?

    0 comments
  2. Anonymous
    2018-09-26T04:59:30+00:00

    thank you for your solution, worked as intended..

    Was this answer helpful?

    0 comments
  3. Anonymous
    2018-09-25T04:36:05+00:00

    link to file

    https://1drv.ms/x/s!AlrlKWFcE1hSgQtFVzsI4vmaCTVf

    you can see my work around in D3, but I cannot drag right

    Was this answer helpful?

    0 comments
  4. Ashish Mathur 101.9K Reputation points Volunteer Moderator
    2018-09-25T00:15:17+00:00

    Hi,

    What happens when you replace the hard coded values with cell references?  Also, have you explored the PowerPivot and Cube formulas?  To get more specific help, share the link from where I can download your workbook and show the expected result there.

    Was this answer helpful?

    0 comments