• The forum (and all other resources in Chandoo.org) will be under maintenance and will be unavailable for a maximum of two hours on the first week of October 2023. The exact date, time and duration of the maintenance are subject to change. We regret the inconvience it may cause.

  • 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

    Hui...

  • 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

D

data_any

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 .
Thanks.
 

Attachments

  • 1.png
    1.png
    14.4 KB · Views: 2
  • 2.png
    2.png
    15.4 KB · Views: 2
  • 3.png
    3.png
    15.4 KB · Views: 2
You must log in or register to reply here.
Back
Top