I have a reporting scenario as follows

Given a time like 1.1998 (Jan 1998) I want the report to show the sum
of Unit sales for the last 12 months and the Unit Sales by month for
the next 12 months each.

On rows I want to display Gender, Marital Status and Product Family. On
Columns I want to display the Sum of Unit Sales for the last 12 months
and then I want to show the unit sales by each of the next 12 months:

A sample is :

================================================== ================
Gender Marital Product Last 12 Jan 1998 ... Dec 1998 Total
Status Family Month
sales
================================================== ================
F S Drink 8700 800 900 ... 980 98900

..
..
================================================== ================

The total is the sum of the last 12 Month sales + the sum of each of
the next 12 month sales shown:

I managed to come this far in the MDX:

select
{[Measures].[Unit Sales]} on columns,
Non Empty {[Gender].Members* [Marital Status].[Marital
Status].Members*[Product].[Product Family].Members} on Rows
from Sales



Please help how can I get the discrete values like sales of each month
for the next 12 months and the sum of last 12 month along column.

Thanks
Karen