The reason I'm using Aggr is because this pivot table was giving me wrong totals as QV pivot tables don't sum row by row - don't ask me why! Otherwise the formula would be just from the second SUM.
So, what I found out was that if I select Mel for example (second screenshot) my calendar unselect MAR as he doesn't have revenue in March and the correct extrapolation is returned. Therefore when I'm calculating the date range in the formula above, I'm guessing my Max(Date) will be null in Mel's case as he doesn't have date in March. Thus QV is returning ZERO when Mel is not selected.
Does anyone have any idea how to fix this problem?