Calculated dimension problem

[#1]

Hi All,

I'm trying to do a graph that have in X axis dates and in Y axis revenues.

The problem is that the dates in the X axies must be:

     For dates before today, the axis is "Execution date" but only those dates that are in the field "Reporting Date"

     For dates after today, the axis is "Actual Recognition Date"

Ayone can find an aproach to it?

Thanks.