Please try Aggregation Based on Dimensions Feature on revenue measure - Aggregation Based on Dimensions - ClearPeaks Blog ClearPeaks Blog
It will works if there are no null values in your fact table.
I don't think this is possible in OBIEE. .. You might either look for a complex sql which can be used in DDR or Opaque view. Best option is to fix this in ETL..
You could possibly do this with a materialized view on the database that didn't have the null quarters, then in the RPD function ship a lag() in your SQL to get the PrevQtr value in your logical column expression.