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?