using getpivotdata as reference point to sum range

[btardo01]

I have a pivot table where my rows are client names an the columns are dates. Is there a way that I can use the getpivotdata function to identify a reference starting point and then sum the prior twelve dates/columns. If there aren't 12 prior dates/column, it would just return zero? I am trying to avoid using an array formula.

thanks