Hi!

You can make it with ParallelPeriod keyword.

F.e. let's take sales in Samples for the Holefoods cube.

To show YearToYear monthly growth in percent add in the pivot calculated measure "YTY growth" with expression:

(DateOfSale.CurrentMember-ParallelPeriod(DateofSale.YearSold,1,DateOfSale.CurrentMember))/ParallelPeriod(DateofSale.YearSold,1,DateOfSale.CurrentMember)

And format: ##.##%

How to use it. 

Place months in a pivot in Rows. Add YTY Calculated Measure to Cols. And add any Measure you want to compare into Measures, f.e. Revenue. 

You'll get following MDX:

 WITH  MEMBER [DateOfSale].[SelectedYear] AS '[DateOfSale].[Actual].[YearSold].$VARIABLE.Year' MEMBER [MEASURES].[YTY growth] AS '(DateOfSale.CurrentMember-ParallelPeriod(DateofSale.YearSold,1,DateOfSale.CurrentMember))/ParallelPeriod(DateofSale.YearSold,1,DateOfSale.CurrentMember)',FORMAT_STRING='###.##%' SELECT NON EMPTY {[Measures].[%COUNT],[MEASURES].[YTY GROWTH]} ON 0,NON EMPTY [DateOfSale].[Actual].[MonthSold].Members ON 1 FROM [HoleFoods]

See the result:

And here are 2011 and 2010 together to prove the measure above works properly:

Hope that helps.

Hi, Scott!

Have you seen Activity Monitor? There was a post about it.

Andrew, I edited your post and deleted all page script from it.

Please attach it as a file to a post or send a screenshot!

Thank you in advance!

Hi, Sylvian!

We used another approach to this problem and find solution which our customers use in production.

Customers wanted sophisticated excel reports from DeepSee. Thay alredy had hundreds of predefined reports in form of Excel.

What we do:

1. Transform this standard Excel reports into excel-xml(save Excel as xml) templates with XSLT variables inside.

2. Programmaticaly run reports in DeepSee, parse the result and perform XSLT transformation under excel-xml templates and data from DeepSee. You can use for this either %DeepSee.ResultSet or %DeepSee.REST.API or MDX2JSON.

3. Get the ready to use Excel reports with data from DeepSee in excel-xml form.

Here are some code examples, presentation and workthrough which are mostly in Russian (except COS).

Hope it helps.