Set Analisys Pivot Table Date dimmension as column: Filter by Date

[GerardoAbal]

I've a Pivot table that show Measeures as row and Year as Column:

The formula "Sum({$<Due_Date={"<=$(=Max(Date))"},Mov_Type={'Customer'}>}Amount)" is not working as intended, because the "Max(Date)" its evaluating as the maximun date of the current selection, but I need to evaluate as the max Date of the current Year (Column)

Anyone know how to achieve these?