InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comFri, 24 May 2013 15:55:48 GMT20http://www.sqlservercentral.com/Forums/Topic1075438-17-1.aspxPlease don't cross post. It just wastes people's time and fragments repliesNo replies to this thread please. Direct replies to [url]http://www.sqlservercentral.com/Forums/Topic1075440-1633-1.aspx[/url]Wed, 09 Mar 2011 05:46:20 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic1075438-17-1.aspxIssue with Parallel PeriodHi,I have a SSRS report, based on Cube, where a table shows information for Employees. The report has a table.Col1 - YearMonth, Col2 - Emp_ID, Col3 - Organisation Unit, and few more columns.All I need to do is get to know which Organisation Unit they belong to in previous month and add this information as an additional column.I want something like below and using With Member create a extra field in the Dataset for the table and create a extra column 'PrevMonthOrganistaion'.[EMPLOYEE].[ORG UNIT],ParallelPeriod ([DATE].[Year Month].[Year Month], 1, [DATE].[Year Month].&[201101]))Not sure how to implement this . Kindly advise.Wed, 09 Mar 2011 04:34:18 GMTsyedathariqbal