• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

How to pull data of pivot table with filter


New Member
I created a pivot table which has dates as rows and engagement on that date as values. Then I put month as a filter to this pivot table.
I managed to work this formula to pull out pivot data : =IF(B62<>"",(GETPIVOTDATA("Engagement",$B$61,"Date",D62)),"")
This works for Jan and Feb but for March and other months, it gives a #REF error in the very first cell and the in the other ones the values comes out in a cell below the correct cell; i.e engagement on date 1 of march is shown in the cell opposite to date 2 of march.
Awaiting a helpful response .


  • 1.png
    14.4 KB · Views: 2
  • 2.png
    15.4 KB · Views: 2
  • 3.png
    15.4 KB · Views: 2