WebFOCUS Totaling on column's computed using the LAST function

[Manoj Chaurasia]

I have a request to add totals to a report on a BY field where on of the columns is computed using the LAST function and the report is an Across Report. The across is on MM/YYY date field. The condition requres that the totals still be calculated using the last value from the previous months with the current months value Something like this

COMPUTE MARGIN_DIFF_PCT/D12.1%=IF (SHIP_MY GT LAST_SHIP_MY AND LAST_SHIP_MY NE '') THEN (CONTRIBUTION_TOTAL - LAST CONTRIBUTION_TOTAL )/ LAST CONTRIBUTION_TOTAL * 100 ELSE 0;

Using a RECAP or RECOMPUTE does get me the correct values. Has anyone had this type of request before

I have added a screenshot of the report I am creating and highlighted the fields which need to be calculated.

Thanks,