crosstab calculations

[mprof]

Hi,

I have a crosstab where columns are months (last 6 months)
and the rows are the data (sales)

                    June     May        April       March       February
Total Sales   1,516   5,523   5,344   5,577   5,347
Daily Average   151.6   178.2   178.1   179.9   191.0


I want to add additional column that shows the change rate between the current and the last month:

                    June        May         April       March       February    change rate
Total Sales   1,516   5,523   5,344   5,577   5,347   
Daily Average   151.6   178.2   178.1   179.9   191.0   -14.91%


please advise.

Thanks

[MDXpressor]

What type of datasource?  Cube or relational?

[mprof]

relational

[MDXpressor]

relational in crosstabs is tricky.

Did you try a column for:

Try (total... for last month) - (total ... for current month)