Hi all,
I have the following issue:
I have created a CrossTab based on a SQL Procedure.
Result: Profit ands Loss Report
               Month    Month    Calculated Member
               Actual   Actual   Budget Last month of Range
Account GL     2009-01  2009-02  2009-02   >> Date Range   
120000 Revenue   1000   5000     1500
130000 CostSales  500   2500     2000
140000 Misc      3000   4000     1000
etc....
My Problem:
I only want the actual amount for each month(this is OK), except the last month I want the budget and Last year amount, for same month. In the procedure I set the Budget Amount = $0 for every month except the last, in the range selected. I then want the calucated member to sum the budget for each Account row.

Hope you get the picture.
Kind Regards,