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