Hi Gurus,
Am I able to sumif a range of dates within a pivot table.
The formula I have is as below, but returns a #ref .
=GETPIVOTDATA("DUE",$A$3,"Group","AP","Payment Date","<"&DATE(2019, 6, 21))
<tbody>
Sum of DUE
Column Labels
Week Ending
AP
CX
1/03/2019
10/05/2019...